Scenario SQL Question
Classify Inventory Levels
Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.
Problem Statement
Classify products as 'Understocked' (stock_level < 20), 'Balanced' (20-100 inclusive), or 'Overstocked' (> 100). Return product_id, product_name, stock_level, inventory_status — ordered by product_id.
Relevant Tables
products
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: