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
Exercises with artists, museums and their pieces of art
Exercises with the band members table
Exercises with tables of Japanese 100 Yen store
Exercises with employees, salaries and benefits

Instruction

Here's the last one in this section!

Exercise

Select the first name and last name of the clients who repurchased products (i.e., bought the same product in more than one order), together with the names of those products and the number of the orders they were part of (name that column OrderCount).

Stuck? Here's a hint!

First, you need to join tables: Clients, Orders, OrderItems, and Products.

Then, group the results by client first name, last name and the name of the product. Use HAVING to filter clients who bought the same product more than once.