Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Revenue Trend Analysis in SQL Server

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.