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
12. Task 7

Instruction

Amazing! Terry has more and more details about his company. Now, he would like to know for which services car parts were not used.

Could you find them for him?

Exercise

Write a query that returns the names of services for which the mechanic didn't use car parts.

Stuck? Here's a hint!

One of the ways to solve this problem is to filter rows by using the NOT IN operator with the subquery. You can learn more about subqueries in Subqueries chapter of the SQL Basics course.

Another way to solve this problem is to use LEFT JOIN and IS NULL.