It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introductory Quiz
5. Exercise 4

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.