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
9. Task 4

Instruction

Terry wants to know which parts in his store are used to repair clients' cars. He wants to look at services that started in April 2020.

Can you help him?

Exercise

Write a query that selects the name of the parts used and the start date of the services, if they are in April 2020. Sort the reults by the start date in ascending order.

Stuck? Here's a hint!

Join tables service, service_part, and part. To find services that began in April 2020, use:

WHERE service.start_date >= '2020-04-01'
  AND service.start_date < '2020-05-01'