[Solved] Identify the error in this query:SELECT product, CASE price > 50 THEN 'Expensive' ELSE 'Cheap' END AS cost_category FROM products; | SQL

SQL - CASE Expressions

Identify the error in this query:

SELECT product, CASE price > 50 THEN 'Expensive' ELSE 'Cheap' END AS cost_category FROM products;

AMissing END keyword

BMissing WHEN keyword after CASE

CMissing ELSE keyword

DIncorrect alias name

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax
CASE must be followed by WHEN before condition; here WHEN is missing.
Step 2: Verify other parts
END and ELSE are present; alias is valid; only WHEN is missing.
Final Answer:
Missing WHEN keyword after CASE -> Option B
Quick Check:
CASE requires WHEN before condition [OK]

Quick Trick: Always use WHEN after CASE [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this query: