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

SQL Practice Set in MS SQL Server

Introduction
Challenge with artists

Instruction

Good job! Keep going!

Exercise

Show the number of pieces of art created by the most productive artist. Rename the column to MostPiecesCreated.

Stuck? Here's a hint!

In the subquery compute the number of pieces of art created by each artist. In the outer query select the largest number among those found in the subquery.