Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the WarrantyRepair table


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

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

  • Id – The ID of the repair
  • CustomerId – The ID of the customer who ordered a given repair
  • RepairCenter – Denotes which warranty center repaired the device (USA, Germany, or Japan)
  • DateReceived – The date when the repair center received the device for repair
  • RepairDuration – The number of days it took to repair the device
  • RepairCost – The USD cost of spare parts used to repair the device (0 in the case of software problems)


Select all information from the WarrantyRepair table.