Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries

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.