[Solved] Identify the error in this Simple CASE query:SELECT ProductName, CASE ProductCategory WHEN 'A' THEN 'Category A' WHEN 'B' 'Category B' ELSE 'Other' END AS CategoryNameFROM Products; | SQL

SQL - CASE Expressions

Identify the error in this Simple CASE query:

SELECT ProductName,
 CASE ProductCategory
   WHEN 'A' THEN 'Category A'
   WHEN 'B' 'Category B'
   ELSE 'Other'
 END AS CategoryName
FROM Products;

ACASE expression should be inside parentheses.

BMissing END keyword at the end.

CIncorrect use of ELSE keyword.

DMissing THEN keyword after WHEN 'B'.

Step-by-Step Solution

Solution:

Step 1: Review each WHEN clause syntax
WHEN clauses must have THEN keyword before the result. The second WHEN is missing THEN.
Step 2: Check other parts of the query
END keyword is present, ELSE is correctly used, parentheses are not required around CASE expression.
Final Answer:
Missing THEN keyword after WHEN 'B'. -> Option D
Quick Check:
WHEN must be followed by THEN [OK]

Quick Trick: Each WHEN must be followed by THEN [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 Simple CASE query: