Introduction
Get to know the database
Basic revenue metrics
Instruction
Well done! We'll now take a look at the products and categories tables.
Each product has a product_id and product_name. Each product belongs to one category (category_id) and has a fixed unit_price. The discontinued column holds either a 0 (available in the store) or a 1 (no longer available) for each product.
Each category has an ID and a category_name. There is also a short description.
Exercise
The products table contains a category_id column, but no category_name column. To find out the category name for a given product, you'll have to join these two tables.
Show each product_name alongside its category_name.
Stuck? Here's a hint!
Join the products and categories tables.
