Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
Intro Quiz
6. Exercise 5

Instruction

Terrific! Here's the last exercise.

Exercise

For each artist, show their first and last name and the minimum, average, and maximum scores of their paintings (as min_rating, avg_rating, max_rating columns). Only show artists with more than two paintings.

Stuck? Here's a hint!

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

Want to refresh your knowledge on how to use the HAVING clause? Take a look at Part 5 of our Basics of PostgreSQL course.