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 – April 2020

Introduction
Resolve Tasks
10. Task 5

Instruction

Fantastic! Terry is happy because, for a lot of services, clients purchased car parts from his store. However, his mechanic, Derek, says that he often needs car parts for the Mondeo model but can only find ones for the Focus model.

Exercise

Show the names of the car parts available for the Focus that aren't available for the Mondeo.

Stuck? Here's a hint!

Find all part names available for Focus. Then use EXCEPT operator to take away part names available for Mondeo.

You can learn more about EXCEPT in Set operators chapter of the course SQL Basics.