Genres Commonly Heard by the Same Listeners

Problem

Table: `plays`

```text
+-------------+------+
| Column Name | Type |
+-------------+------+
| listener_id | int |
| track_id | int |
| play_count | int |
+-------------+------+
There is no single-column primary key. Each row records that a listener
played a track some number of times.
```

Table: `tracks`

```text
+-------------+---------------+
| Column Name | Type |
+-------------+---------------+
| track_id | int |
| genre | varchar |
| length_sec | decimal(10,2) |
+-------------+---------------+
track_id is the primary key for this table.
```

Find every pair of genres for which at least three distinct listeners played a track from both genres. Treat each pair once, with the alphabetically smaller genre first.

Return `genre1`, `genre2`, and `listener_count`, ordered by `listener_count` descending, then `genre1` ascending, then `genre2` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns genre1, genre2, listener_count.

Starter code (SQL)

SELECT *
FROM plays;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard