Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
4. The Customer table
CTEs with data modifying statements


Now, the next table is the Customer table. It contains customer details like their name, age, city, and shopper discount amount.


Select all information from the Customer table.

This table has the following columns:

  • Id – the identifier of the customer,
  • FirstName – the first name of the customer,
  • LastName – the last name of the customer,
  • City – the name of the city in which that customer lives,
  • Age – the age of the customer,
  • Discount – the customer's discount.