Instruction
Good job! Let's move on.
Exercise
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.
