Practice intermediate SQL question: LEFT JOIN: All Artists Including Those Without Albums

Solve this interactive intermediate question online in our browser coding environment.

LEFT JOIN: All Artists Including Those Without Albums

intermediate~6 min25 pts

An INNER JOIN only returns matching rows. Use LEFT JOIN to include ALL artists, even those without any albums.

Write a query showing all artists with their album counts, including artists with zero albums.

Column	Type
ArtistId	INTEGER (Primary Key)
Name	TEXT

Column	Type
AlbumId	INTEGER (Primary Key)
Title	TEXT
ArtistId	INTEGER (Foreign Key → Artist.ArtistId)

Use LEFT JOIN to include all artists
Count albums per artist (NULL-safe)
Return ArtistName and AlbumCount
Order by AlbumCount ascending to see artists with 0 albums first, then ArtistName ascending to break ties
Limit to 20 rows

Returns all rows from the left table, plus matching rows from the right. Non-matching right-side rows are NULL.

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

intermediate~6 min25 pts

An INNER JOIN only returns matching rows. Use LEFT JOIN to include ALL artists, even those without any albums.

Write a query showing all artists with their album counts, including artists with zero albums.

Column	Type
ArtistId	INTEGER (Primary Key)
Name	TEXT

Column	Type
AlbumId	INTEGER (Primary Key)
Title	TEXT
ArtistId	INTEGER (Foreign Key → Artist.ArtistId)

Use LEFT JOIN to include all artists
Count albums per artist (NULL-safe)
Return ArtistName and AlbumCount
Order by AlbumCount ascending to see artists with 0 albums first, then ArtistName ascending to break ties
Limit to 20 rows