[Solved] Find the problem in this query:SELECT product, price FROM Items ORDER BY CASE price WHEN > 100 THEN 1 ELSE 2 END; | SQL

SQL - CASE Expressions

Find the problem in this query:

SELECT product, price FROM Items ORDER BY CASE price WHEN > 100 THEN 1 ELSE 2 END;

AORDER BY cannot use CASE with numeric columns

BMissing ELSE clause in CASE

CIncorrect CASE WHEN syntax; cannot use comparison operator directly after WHEN

DMissing END keyword

Step-by-Step Solution

Solution:

Step 1: Review CASE WHEN syntax
WHEN expects a value to compare, not a condition with > operator.
Step 2: Correct usage
Use CASE WHEN price > 100 THEN 1 ELSE 2 END for conditions.
Final Answer:
Incorrect CASE WHEN syntax; cannot use comparison operator directly after WHEN -> Option C
Quick Check:
WHEN needs condition after WHEN keyword [OK]

Quick Trick: Use WHEN condition THEN, not WHEN value > x THEN [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the problem in this query: