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 < 20), 'Balanced' (stock 20-100), or 'Overstocked' (stock > 100). Return product name, current stock, and classification.

Relevant Tables

products

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

CASE Statements & Conditional LogicSQL Fundamentals
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
Complex WHERE Conditions & Boolean LogicAdvanced Filtering