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


Finally, the last table is customer_order.

In this table we find all orders made by customers. Each order has an order number, year, id of the store in which order was placed, and customer satisfaction points for the order.


Select all information from the customer_order table.

This table consists of fields:

  • id – identifier of the order,
  • order_number – number of order,
  • order_year – year when the order was placed,
  • customer_id – ID of the customer,
  • grocery_store_id – ID of the grocery_store,
  • points – customer satisfaction rating on order, on a scale from 0 to 5.