SQL Quest › SQL Interview Questions › Aggregation & Grouping
Genre-Spanning Directors (HAVING)
A film studies report wants directors who have worked in more than one genre — a signal of stylistic range. Show director and genre_count (COUNT(DISTINCT genre)). Filter with HAVING COUNT(DISTINCT genre) > 1. Order by genre_count descending, then director ascending.
The DISTINCT inside the HAVING aggregate is the whole trick: a director with five Action movies has COUNT(*) = 5 but COUNT(DISTINCT genre) = 1, and we only want the second number.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.
Schema
movies
| id | title | year | genre | rating | votes | revenue_millions | runtime | director |
|---|---|---|---|---|---|---|---|---|
| 1 | Guardians of the Galaxy | 2014 | Action | 8.1 | 757074 | 333.13 | 121 | James Gunn |
| 2 | Prometheus | 2012 | Adventure | 7 | 485820 | 126.46 | 124 | Ridley Scott |
| 3 | Split | 2016 | Horror | 7.3 | 157606 | 138.12 | 117 | M. Night Shyamalan |
Expected output: Only Christopher Nolan appears
Hint
SELECT, GROUP BY, HAVING, and open the hint there if you stall.Concepts
SELECT GROUP BY HAVING COUNT DISTINCT
Practise the topic: SQL practice questions · GROUP BY exercises
Read the concept: SQL GROUP BY tutorial
In these company practice sets
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test