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


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.


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.