Top 3 Streamed Tracks

SQLEasyJunior levelSpotify~15 min

Problem

**[Asked at Spotify]**

Spotify logs daily stream counts for every track. Find the **3 most-streamed tracks
overall** (summed across all days in the table).

Return `track_name` and `total_streams`, ordered by total streams descending.

Example rows — the live problem includes the full dataset.

daily_streams

stream_id	track_name	artist	stream_count	stream_date

Your answer should return 3 rows with the columns track_name, total_streams.

SELECT *
FROM daily_streams;

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.