Label moderation queue items by urgency
The trust & safety team wants each item in the moderation queue labeled by urgency: 'Auto-removed' for content flagged 10 or more times, 'Priority review' for 3 to 9 flags, and 'Standard queue' for anything below that.
Return content_id, flag_count, and label.
Schema
▸moderation_queue
| id | INT |
| content_id | TEXT |
| flag_count | INT |
Example input
▸moderation_queue
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.