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
8. Task 3

Instruction

You helped Terry find very important information! He now knows what to do to boost his services. His clients will be more satisfied!

Terry is interested in selecting from the database the names of the car parts with more than 5 subparts.

Exercise

Select the names of the car parts and the number of subparts if the number of subparts is more than 5. Sort rows in descending order according to the number of subparts. Rename the columns to part_name and subparts_number.

Stuck? Here's a hint!

Use a self join to connect data about subparts to car parts. For more information, take the course SQL JOINs.