Top-Streamed Track in Each Genre

Problem

A music service stores monthly stream counts per track, and each track belongs to a genre.

Table: `tracks`

| Column | Type |
|-------------|---------|
| track_id | int |
| track_name | varchar |
| streams | int |
| genre_id | int |

`track_id` is the primary key; `genre_id` references `genres.genre_id`.

Table: `genres`

| Column | Type |
|-------------|---------|
| genre_id | int |
| genre_name | varchar |

`genre_id` is the primary key.

Write a query that returns, for each genre, the track(s) with the **highest** stream count in that genre. If several tracks tie for the most streams in a genre, return all of them.

Return three columns named `genre`, `track`, and `streams`, in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns genre, track, streams.

Starter code (SQL)

SELECT *
FROM tracks;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium