Psst! Check what courses we have in our offer, and get them all here to save $727. Tick-tock—this deal ends on 3/21.
Introduction
5. The Purchase table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE and DELETE with JOIN
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

Finally, we come to the last table, Purchase. Let's explore it.

Exercise

Select all columns from the Purchase table. In this store, each purchase is for one kind of product. It consists of the following columns:

  • Id – uniquely identifies each order.
  • ProductId – the ID of the product included in the order.
  • Quantity – how many of each product is in the order.
  • TotalPrice – the total amount for those products.
  • CustomerId – the ID of the customer who bought the order.
  • EmployeeId – the ID of the employee who sold the order.
  • OrderDate – the date on which the order was placed.
  • IsCompleted – a boolean value denoting if the purchase was completed (1) or not (0). Note that the values are displayed as true and false, respectively.