Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. The Product table
CTEs with data modifying statements


OK. Now the second table: Product. It contains details about the items sold in the grocery stores.


Select all the information from the Product table. This table consists of the columns:

  • Id – the identifier of the product/grocery store combination,
  • Name – the name of the product,
  • Price – the price of the product,
  • GroceryStoreId – the ID of the grocery store in which the product is stocked.