Scenario SQL Question
Nested CASE - Classify Sales with Discount by Customer Type
Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.
Problem Statement
Classify sales with discounts based on amount and customer type: High value (> 100000) Corporate gets 20% discount, High value Government gets 18% discount, High value Individual gets 15% discount. Medium value (50000-100000) Corporate gets 15% discount. Standard discount for others. Return sale details and final discount percentage.
Relevant Tables
sales
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: