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

GROUP BY Extensions in SQL

Introduction
2. Get to know the warranty_repair table
Summary

Instruction

Let's get to know the tables we'll be working with in this part.

We'll use a table named warranty_repair in our examples. It has the following columns:

  • id – the ID of the repair.
  • customer_id – the ID of the customer who ordered a given repair.
  • repair_center – denotes which warranty center repaired the device (USA, Germany, or Japan).
  • date_received – the date when the repair center received the device for repair.
  • repair_duration – the number of days it took to repair the device.
  • repair_cost – the USD cost of spare parts used to repair the device (0 in the case of software problems).

Exercise

Select all information from the warranty_repair table.