Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introductory Quiz
5. Exercise 4


Good job! Let's move on.


For each painter, show their first and last name together with the number of paintings they have painted. The names of the columns should be: first_name, last_name, and paintings_no.

Stuck? Here's a hint!

Use a COUNT() function and GROUP BY both the first and the last name of the artist.

Want to refresh your knowledge of SQL basics? Take a look at the SQL Queries course, Part 4: Aggregation and grouping.