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
6. Task 1

Instruction

Terry has a lot of Ford parts in his new store. From time to time, he expands his selection of parts for new models. Therefore, he wants to know more about the parts he has. Could you help him?

Exercise

Write a query to select the IDs and names of the universal (for all Ford models) car parts, that is the parts for which there is no model assigned.

Stuck? Here's a hint!

Remember, universal car parts have NULL in the model_id column in the table part. Use the IS NULL operator. Learn more in the course SQL Basics.