Given a dataset of flagged content on TikTok, how would you write a query to determine the top 5 most common policy violations?
Use the provided flagged-content records and policy reference data. Return recognized policy violations only, with ties ordered alphabetically.
policy_name and violation_countviolation_count descending, then policy_name ascending| Column | Type | Description |
|---|---|---|
| content_idPK | INT | Unique identifier for the flagged content item |
| policy_id | INT | Policy associated with the flagged content |
| Column | Type | Description |
|---|---|---|
| policy_idPK | INT | Unique identifier for a policy violation type |
| policy_name | VARCHAR(100) | Human-readable policy violation name |