[Solved] Given the table Orders with column StatusCode, what will this query return?SELECT OrderID, CASE StatusCode WHEN 1 THEN 'Pending' WHEN 2 THEN 'Shipped' ELSE 'Unknown' END AS Status FROM Orders; | SQL

SQL - CASE Expressions

Given the table Orders with column StatusCode, what will this query return?

SELECT OrderID, CASE StatusCode WHEN 1 THEN 'Pending' WHEN 2 THEN 'Shipped' ELSE 'Unknown' END AS Status FROM Orders;

AOrderID with status always 'Unknown'

BOrderID with status as '1' or '2' only

COrderID with status as 'Pending' for 1, 'Shipped' for 2, else 'Unknown'

DSyntax error due to missing ELSE

Step-by-Step Solution

Solution:

Step 1: Understand CASE evaluation
CASE compares StatusCode to 1 or 2, returns matching string.
Step 2: Check ELSE usage
ELSE returns 'Unknown' if no match; no syntax error.
Final Answer:
OrderID with status as 'Pending' for 1, 'Shipped' for 2, else 'Unknown' -> Option C
Quick Check:
CASE maps codes to strings correctly [OK]

Quick Trick: ELSE handles unmatched values in CASE [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table Orders with column StatusCode, what will this query return?