[Solved] Identify the error in this searched CASE expression:SELECT Name, CASE WHEN Age > 18 THEN 'Adult' WHEN Age < 18 THEN 'Minor' END AS AgeGroup FROM People; | SQL

SQL - CASE Expressions

Identify the error in this searched CASE expression:

SELECT Name, CASE WHEN Age > 18 THEN 'Adult' WHEN Age < 18 THEN 'Minor' END AS AgeGroup FROM People;

AIncorrect use of THEN keyword

BNo error, query is correct

CNo END keyword to close CASE

DMissing ELSE clause for other cases

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax completeness
The CASE has WHEN conditions, THEN results, and ends with END keyword properly.
Step 2: Consider ELSE clause necessity
ELSE is optional; if no ELSE, NULL is returned for unmatched cases, which is valid.
Final Answer:
No error, query is correct -> Option B
Quick Check:
ELSE optional, END required, syntax correct [OK]

Quick Trick: ELSE is optional; END is mandatory [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 searched CASE expression: