It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Product table
Using CTEs with data-modifying statements
Summary

Instruction

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

Exercise

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.