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
2. Table model
Resolve Tasks

Instruction

First, let's get to know the tables in Terry's database, ford_service. It has four tables: model, part, service, and service_part.

The first table, model, stores details about Ford models, which car parts are sold in Terry's store, and which parts are used to repair the cars in Terry's workshop.

Exercise

The model table contains two columns:

  • id – the model's unique ID.
  • name – the model's name.

Select all data from the table model.