Exercise: INNER JOIN

Show each artist's name and the title of their album using INNER JOIN between artists and albums. Order by artist name.

Show each track's title and the name of its genre. Chain three tables (tracks, albums, genres) with INNER JOIN. Order by track title.

Show stream_id, username, and track title for every stream made by a user on the 'free' subscription tier. Use INNER JOIN across streams, users, and tracks. Order by started_at.

For each artist, show the name and the total number of streams across all their tracks. Chain four tables. Order by total_streams descending, then by artist name.

For each user who has streamed something, count the number of distinct artists they have listened to. Use INNER JOIN across the full chain of tables. Show username and artists_listened. Order by artists_listened descending, then by username.