Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
5. Table customer_order
CTEs with data modifying statements
Summary

Instruction

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.

Exercise

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.