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 in PostgreSQL

Introduction
5. Customer_order table
Using CTEs with data-modifying statements
Summary

Instruction

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.

Exercise

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.