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
5. Table service_part
Resolve Tasks

Instruction

The fourth table, service_part, stores details about the services and parts from Terry's store used to repair cars.

Exercise

The service_part table contains these columns:

  • service_id – the ID of the service.
  • part_id – the ID of the part.

If the mechanic didn't need parts for the repair, or if the customer had their own parts, no entries are made in this table. However, if the mechanic used parts from the store for the repair, the IDs of the services and parts are stored in this table.

Select all data from the table service_part.