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
3. Table part
Resolve Tasks

Instruction

The second table, part, stores details about the Ford car parts for sale in Terry's store.

Exercise

The part table shows hierarchical information about the car parts. It contains these columns:

  • id – the unique ID of the part.
  • name – the name of the part.
  • price – the price of the part.
  • registered_date – the registered date of the part.
  • model_id – the Ford model (universal parts for all models have NULL in this column).
  • parent_id – the ID of the parent part, if any (main parts have NULL in this column because they don't belong to any parent part). For example, the car body is a parent part built of an engine and other parts, and an engine is a parent part built of cylinders, pistons, and other parts.

Explore the contents of the table part by selecting all data from it.