Scenario SQL Question

Assign Customer Loyalty Tiers

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

Problem Statement

Build customer loyalty tiers from total spending: 'Bronze' (< 1000), 'Silver' (1000-5000), 'Gold' (> 5000 and ≤ 10000), 'Platinum' (> 10000). Return customer_id, customer_name, total_spending, loyalty_tier — ordered by customer_id.

Relevant Tables

customers

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