End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Get to know the database
5. The Products and Categories tables
Basic revenue metrics
Summary

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.