Introduction
4. The Customer table
CTEs with data modifying statements
Summary

Instruction

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

Exercise

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.