Introduction
CTEs with data modifying statements
Instruction
Now, the next table is table customer. It contains customer details: name, age, city, and shopper discount.
Exercise
Select all information from the customer table.
This table has the following columns:
id– identifier of the customer,first_name– first name of the customer,last_name– last name of the customer,city– name of city in which customer lives,age– age of the customer,discount– customer discount.
