Introduction
5. The CustomerOrder table
CTEs with data modifying statements
Summary

## Instruction

Finally, the last table is called CustomerOrder.

In this table, we find all the orders placed by customers. Each order has an order number, a year, the ID of the store in which the order was placed, and a number of customer satisfaction points given to that order.

## Exercise

Select all information from the CustomerOrder table.

This table consists of the fields:

• Id – the identifier of the order,
• OrderNumber – the number of that order,
• OrderYear – the year when the order was placed,
• CustomerId – the ID of the customer,
• GroceryStoreId – the ID of the GroceryStore,
• Points – the customer's satisfaction rating for that order, on a scale of 0 to 5.