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

Recursive Queries in MS SQL Server

Introduction
Quiz
9. Exercise 5
Congratulations

Instruction

Excellent! Now go on to the last exercise.

Exercise

A lot of people like sweets very much. We're willing to bet you do, too! Which recipes include sweets? Get the Names of recipes that include at least one ingredient of the type N'sweets' but not the N'sugar' type.

Stuck? Here's a hint!

You may want to review material about subqueries in the SQL Basics in SQL Server course, Part 6: Subqueries.