Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Get to know the database
5. The products and categories tables
Summary

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.