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 ProductId and ProductName. Each product belongs to one category (CategoryId) and has a fixed UnitPrice. 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 CategoryName. There is also a short Description.
Exercise
The Products table contains a CategoryId column, but no CategoryName column. To find out the category name for a given product, you'll have to join these two tables.
Show each ProductName alongside its CategoryName.
Stuck? Here's a hint!
Join the Products and Categories tables.
