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 MS SQL Server

Introduction
5. The CustomerOrder table
CTEs with data modifying statements
Summary

Instruction

Finally, the last table is called CustomerOrder.

In this table, we find all the orders placed by customers. Each order has an order number, a year, the ID of the store in which the order was placed, and a number of customer satisfaction points given to that order.

Exercise

Select all information from the CustomerOrder table.

This table consists of the fields:

  • Id – the identifier of the order,
  • OrderNumber – the number of that order,
  • OrderYear – the year when the order was placed,
  • CustomerId – the ID of the customer,
  • GroceryStoreId – the ID of the GroceryStore,
  • Points – the customer's satisfaction rating for that order, on a scale of 0 to 5.