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)