[Solved] Identify the error in this SQL query:SELECT name, CASE salary > 10000 THEN 'Rich' ELSE 'Average' END AS status FROM users; | SQL

SQL - CASE Expressions

Identify the error in this SQL query:

SELECT name, CASE salary > 10000 THEN 'Rich' ELSE 'Average' END AS status FROM users;

AMissing WHEN keyword after CASE

BMissing END keyword

CMissing ELSE keyword

DMissing AS keyword for alias

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax
The CASE statement must have WHEN before the condition. Here, WHEN is missing.
Step 2: Verify other parts
END and ELSE are present, AS is used correctly, so no errors there.
Final Answer:
Missing WHEN keyword after CASE -> Option A
Quick Check:
CASE requires WHEN before condition [OK]

Quick Trick: Always write WHEN after CASE before condition [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 SQL query: