[Solved] Find the error in this query:SELECT id, CASE WHEN age >= 18 THEN 'Adult' ELSE 'Minor' AS age_group FROM users; | SQL

SQL - CASE Expressions

Find the error in this query:

SELECT id, CASE WHEN age >= 18 THEN 'Adult' ELSE 'Minor' AS age_group FROM users;

AMissing ELSE keyword

BMissing END keyword before alias

CIncorrect alias name

DMissing WHEN keyword

Step-by-Step Solution

Solution:

Step 1: Check CASE statement completeness
The CASE expression must end with END before alias; here END is missing.
Step 2: Confirm other parts
WHEN and ELSE are present; alias is valid; only END is missing.
Final Answer:
Missing END keyword before alias -> Option B
Quick Check:
CASE expressions must end with END [OK]

Quick Trick: Always close CASE with END before alias [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this query: