Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.