SQL Coding With Joins and Aggregates | Dataford Interview Questions

Describe how you would solve a SQL coding problem involving joins, aggregation, and ranking or filtering logic.

Using the provided tables, write a query that evaluates qualifying artist performance for January 2026.

Output

Return one row per qualifying artist with artist_name, genre, total_streams, genre_rank, and unique_listeners.
Include artists with at least two distinct listeners, return the top two ranks per genre including ties, and order by genre, genre_rank, and artist_name.

artists

tracks

Column	Type	Description
track_idPK	INT	Unique track identifier
artist_id	INT	Artist who recorded the track
track_title	VARCHAR(150)	Track title

streams

Column	Type	Description
stream_idPK	INT	Unique stream event identifier
track_id	INT	Streamed track
listener_id	INT	Listener identifier, nullable for anonymous streams
streamed_at	TIMESTAMP	Timestamp when the stream occurred

Your question is SQL Coding With Joins and Aggregates. Start with the requirements and the three 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.