Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in PostgreSQL

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.