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


OK. Now the second table, product. It contains details about the items sold in the grocery stores.


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

  • id – An identifier for each product/grocery store combination.
  • name – The name of the product.
  • price – The price of the product.
  • grocery_store_id – The ID of the grocery store where the product is stocked.