Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the database
5. The products and categories tables


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.


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.