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 Coding Challenge – May 2020

Introduction
Tasks
13. Task 8

Instruction

Good news! Lisa found a new chocolate supplier with a better price. This will save money on cakes that include the dark, white or milk chocolate.

Lisa wants to show Mark which cakes will be affected by this change. Can you do it?

Exercise

For cakes that are made with 'dark chocolate', 'white chocolate', or 'milk chocolate', select all non-repeating cake names and their prices.

Stuck? Here's a hint!

Use DISTINCT in the SELECT and the IN operator in WHERE with a list of chocolates.

If you need help, check out our SQL Basics course.