Kickstart 2020 with new opportunities! - 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.