[Solved] Which of the following SQL snippets correctly demonstrates the syntax of a Simple CASE expression? — Ans: SELECT Name, CASE Status WHEN 'A' THEN 'Active' WHEN 'I' THEN 'Inactive' ELSE... | SQL

SQL - CASE Expressions

Which of the following SQL snippets correctly demonstrates the syntax of a Simple CASE expression?

ASELECT Name, CASE WHEN Status = 'A' THEN 'Active' WHEN Status = 'I' THEN 'Inactive' ELSE 'Unknown' END AS StatusDesc FROM Users;

BSELECT Name, CASE Status WHEN 'A' THEN 'Active' WHEN 'I' THEN 'Inactive' ELSE 'Unknown' END AS StatusDesc FROM Users;

CSELECT Name, CASE Status WHEN 'A' THEN 'Active' ELSE 'Inactive' END StatusDesc FROM Users WHERE Status = 'A';

DSELECT Name, CASE Status WHEN 'A' THEN 'Active' WHEN 'I' THEN 'Inactive' END StatusDesc FROM Users WHERE Status = 'I';

Step-by-Step Solution

Solution:

Step 1: Identify Simple CASE syntax
Simple CASE syntax is: CASE expression WHEN value THEN result ... ELSE default END
Step 2: Analyze options
SELECT Name, CASE Status WHEN 'A' THEN 'Active' WHEN 'I' THEN 'Inactive' ELSE 'Unknown' END AS StatusDesc FROM Users; correctly uses CASE with expression 'Status' and multiple WHEN clauses.
Step 3: Check other options
SELECT Name, CASE WHEN Status = 'A' THEN 'Active' WHEN Status = 'I' THEN 'Inactive' ELSE 'Unknown' END AS StatusDesc FROM Users; uses searched CASE syntax (CASE WHEN condition THEN ...), not Simple CASE.
Final Answer:
SELECT Name, CASE Status WHEN 'A' THEN 'Active' WHEN 'I' THEN 'Inactive' ELSE 'Unknown' END AS StatusDesc FROM Users; correctly shows Simple CASE syntax.
Quick Check:
Simple CASE uses CASE expression WHEN value THEN ... [OK]

Quick Trick: Simple CASE uses CASE expression WHEN value THEN ... [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following SQL snippets correctly demonstrates the syntax of a Simple CASE expression?