Scenario SQL Question

Classify Products by Price Range

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

Problem Statement

Classify products by price: 'Free Item' (price = 0), 'Consumer Goods' (1-100), 'Electronics' (101-500), 'Luxury Items' (501-1500), 'Premium' (> 1500). Return product_id, product_name, price, product_category — 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