Introduction
INSERT with SELECT
Referring to other tables
INSERT, UPDATE and DELETE with JOIN
INSERT, UPDATE, and DELETE with subqueries
Summary
Instruction
The Product table describes the products we sell.
Exercise
Select all columns from the Product table. It contains:
Id– uniquely identifies each product type in our warehouse.Name– the name of the product.Price– the price per one unit of that product.DeliveredDateTime– when the product was delivered to our warehouse.PriceDateTime– the date of the most recent price change for that product.
