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 MS SQL Server

Introductory quiz
6. Exercise 5

Instruction

Terrific! Let's try the last exercise.

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.