Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close
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.