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


The last table is customer_order. It contains records of all orders made by customers. Each order has an order number, a year, a store ID, and a number of satisfaction points awarded by the customer.


Select all information from the customer_order table.

This table consists of these fields:

  • id – An identifier for each order.
  • order_number – The order number.
  • order_year – The year when the order was placed.
  • customer_id – The ID of the customer who placed the order.
  • grocery_store_id – The ID of the grocery_store that handled the order.
  • points – Satisfaction points, on a scale from 0 to 5, given by the customer to that order.