Top 10 Most Watched Query | Dataford Interview Questions

Write a query to find the top 10 most watched anime series from a dataset.

Use the provided anime_series and watch_events tables. Calculate total watches per series, include series with no valid watch events, and return fewer than 10 rows only if fewer than 10 series exist.

Output

One row per anime series with columns series_title and total_watches
Include the 10 highest totals, treating missing or NULL watch counts as zero
Order by total_watches descending, then series_title ascending for ties

Schema

anime_series

Column	Type	Description
series_idPK	INTEGER	Unique identifier for an anime series
series_title	VARCHAR(200)	Anime series title

watch_events

Column	Type	Description
event_idPK	INTEGER	Unique identifier for a watch event
series_id	INTEGER	Referenced anime series identifier
watch_count	INTEGER	Number of watches represented by the event

Your question is Top 10 Most Watched Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem