Top Content Flagger

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

In err_tracks, the pair (err_type, svc_name) identifies a reporter. Count distinct err_id rows per reporter, scoped to services (svc_name) that have at least one resolved alert in alert_events (resolved is not NULL). Return all reporters tied at the highest distinct flag count. The reporter_identity is err_type || '-' || svc_name. Include ties. Sort alphabetically by reporter_identity.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.