Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Method One
3. Method 1 – exercise 1
Method Two
Method Three


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


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.