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 MS SQL Server

Introduction
2. Get to know the WarrantyRepair table
Summary

Instruction

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)

Exercise

Select all information from the WarrantyRepair table.