Scenario SQL Question

Product Performance Classification

Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.

Problem Statement

Classify products: 'Premium Fast-Moving' (price > 500 AND stock_level < 20), 'Budget High-Stock' (price < 100 AND stock_level > 100), 'Standard' otherwise. Return product_id, product_name, price, stock_level, product_classification — ordered by product_id.

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