Most Versatile Studios

Problem

Table: `studio`

| Column Name | Type |
|---|---|
| studio_id | int |
| signup_date | date |
| home_genre | varchar(10) |

`studio_id` is the primary key. `home_genre` is the genre the studio is best known for.

Table: `release`

| Column Name | Type |
|---|---|
| release_id | int |
| release_date | date |
| track_id | int |
| studio_id | int |

`release_id` is the primary key. Each row is one track that a studio released.

Table: `track`

| Column Name | Type |
|---|---|
| track_id | int |
| genre | varchar(10) |

`track_id` is the primary key.

A studio shows range when it releases tracks in a genre other than its own `home_genre`. For each studio, count how many *distinct* tracks it released whose `genre` differs from the studio's `home_genre`. Return the studio (or studios, on a tie) with the highest such count, as `studio_id` and `outside_tracks`, ordered by `studio_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns studio_id, outside_tracks.

Starter code (SQL)

SELECT *
FROM studio;

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