SQL Quest › SQL Interview Questions › Aggregation & Grouping

Genre Financial Report

MediumFreeQuerying BasicsAggregation & GroupingConditional Logic

For genres with at least 5 movies, show exactly these 6 columns, in this order: genre, movie_count, avg_rating (2 dec), total_revenue (excluding NULLs, 1 dec), avg_revenue_per_film (1 dec), revenue_missing (count of films with no revenue data). Sort by total_revenue descending.

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".

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: Genres with 5+ films and full financial stats

Hint

SUM(CASE WHEN revenue_millions IS NULL THEN 1 ELSE 0 END) counts missing revenues. SUM/AVG of revenue_millions automatically excludes NULLs

Concepts

SELECT GROUP BY HAVING Aggregation CASE

Practise the topic: SQL practice questions · GROUP BY exercises · CASE WHEN practice

In these company practice sets

Snowflake · Spotify

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Genre Financial Report

Schema

Hint

Concepts

In these company practice sets

Related questions