End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
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.