Write a SQL query to identify the top three most-watched genres for users who signed up in the last 30 days at Tubi.
Use the provided user, watch history, and content data. Treat total watch minutes as the measure of most-watched, exclude records without a genre, and use alphabetical order to break ties.
genre and total_watch_minutes.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique Tubi user identifier |
| signup_date | DATE | Date the user signed up |
| Column | Type | Description |
|---|---|---|
| watch_idPK | INT | Unique viewing event identifier |
| user_id | INT | User who watched the content |
| content_id | INT | Watched content identifier |
| watch_minutes | INT | Minutes watched during the viewing event |
| Column | Type | Description |
|---|---|---|
| content_idPK | INT | Unique Tubi content identifier |
| title | VARCHAR(150) | Content title |
| genre | VARCHAR(50) | Primary content genre |