[Solved] What will this SQL query output?SELECT Product, CASE WHEN Stock = 0 THEN 'Out of stock' WHEN Stock < 5 THEN 'Low stock' ELSE 'In stock' END AS Status FROM Inventory; | SQL

SQL - CASE Expressions

What will this SQL query output?

SELECT Product, CASE WHEN Stock = 0 THEN 'Out of stock' WHEN Stock < 5 THEN 'Low stock' ELSE 'In stock' END AS Status FROM Inventory;

AProduct names with stock status as 'Out of stock', 'Low stock', or 'In stock'

BOnly products with stock equal to zero

CTotal count of products grouped by stock status

DSyntax error due to multiple WHEN clauses

Step-by-Step Solution

Solution:

Step 1: Understand multiple WHEN conditions in CASE
The CASE checks Stock value and returns different text for zero, less than five, or others.
Step 2: Predict output
The query lists all products with a Status column showing the correct stock message.
Final Answer:
Product names with stock status as 'Out of stock', 'Low stock', or 'In stock' -> Option A
Quick Check:
CASE handles multiple conditions correctly [OK]

Quick Trick: Multiple WHENs let CASE handle many conditions [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will this SQL query output?