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

Creating Basic SQL Reports in SQL Server

Introduction
Method One
3. Method 1 – exercise 1
Method Two
Method Three
Summary

Instruction

Good job! Let's do two more exercises using this technique. Here's the first one.

Exercise

Count the number of products with low, average, and high availability. Show two columns: Availability (N'Low' for 10 units or less, N'Average' for 10 to 30 units, or N'High' for more than 30 units) and ProductCount.

Stuck? Here's a hint!

Use the UnitsInStock column from the Products table.