Introductory quiz
6. Exercise 5

## Instruction

Terrific! Let's move on to the last exercise.

## Exercise

For each artist, show their first and last name, the average, minimal and maximal scores from all their paintings. Only show those artists who have more than 2 paintings.

### Stuck? Here's a hint!

This time you will need to use the HAVING clause. Make sure to put it at the end of your query.

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

Code editor

TableConsole