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.

Stuck? Here's a hint!

Don't forget about using GROUP BY.

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

Console

Code editor

Result

TableConsole