Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.