SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy

Top N by Composite Sort for Fraud Queue

Return top 200 unresolved fraud alerts for country='US' ordered by risk_score desc then created_at asc.

Schema Context

fraud_alerts(alert_id, country, status, risk_score, created_at)