Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introductory quiz
6. Exercise 5


Terrific! Let's try the last exercise.


Show each artist's first and last name, their average rating (as AvgRating), and their lowest and highest ratings (as MinRating and MaxRating). Only include those artists who have more than two paintings.

Stuck? Here's a hint!

You'll need the HAVING clause. Make sure to put it at the end of your query.

If you need more help, check out SQL Basics in SQL Server, Part 4: Aggregation and grouping.