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 ('Low' for 10 units or less, 'Average' for 10 to 30 units, or 'High' for more than 30 units) and product_count.

Stuck? Here's a hint!

Use the units_in_stock column from the products table.