SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedQuery-Based Questionsm1 optimizer cardinality internals

Selectivity Probe for Fraud Rules

Write SQL to return rule_id and hit_count for fraud_hits where severity = 'HIGH' in the last 12 hours, sorted by hit_count desc and limited to 20.

Schema Context

fraud_hits(hit_id, rule_id, severity, created_at)