Scenario SQL Question
Complex Multi-Table Conditional Logic
Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.
Problem Statement
Classify each customer: 'VIP' if total_spending > 5000 AND any single order has quantity ≥ 50; 'Regular' if total_spending > 2000 (and not VIP); 'New' otherwise. Return customer_id, customer_name, total_spending, max_quantity, customer_classification — ordered by customer_id.
Relevant Tables
customersorders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: