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
11. Task 6

Instruction

Terry has another problem to solve. He needs data about his services and the total price of the car parts used for the repairs.

Exercise

Get the name of each service and the sum of the prices of the car parts used for each service. Rename the second column to parts_cost. Consider only services for which some car parts must be bought.