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

Instruction

Excellent! Terry found the universal parts. Now, he thinks it would be interesting to see a list of car parts that are universal or intended for models other than the Focus. Are there a lot of these?

Exercise

For each car model except for Focus, select the model name and their parts names or NULL if there's no part dedicated to this model. Rename the columns to model_name and part_name.

Stuck? Here's a hint!

You can use LEFT JOIN (or RIGHT JOIN) to connect the table part with the table model. You can find more information in the course SQL Basics or in the course SQL JOINs.