[Solved] Given the table orders with columns category and amount, what does this query return?SELECT category, SUM(CASE WHEN amount > 100 THEN 1 ELSE 0 END) AS big_orders FROM orders GROUP BY category; | SQL

SQL - CASE Expressions

Given the table orders with columns category and amount, what does this query return?
SELECT category, SUM(CASE WHEN amount > 100 THEN 1 ELSE 0 END) AS big_orders FROM orders GROUP BY category;

ATotal amount of orders per category where amount is greater than 100

BNumber of orders per category regardless of amount

CNumber of orders per category where amount is greater than 100

DSum of all amounts per category

Step-by-Step Solution

Solution:

Step 1: Analyze the CASE inside SUM
CASE returns 1 if amount > 100, else 0, so SUM counts how many orders exceed 100 per category.
Step 2: Understand GROUP BY effect
Grouping by category aggregates counts per category, showing number of big orders per category.
Final Answer:
Number of orders per category where amount is greater than 100 -> Option C
Quick Check:
SUM(CASE) counts condition per group [OK]

Quick Trick: SUM(CASE) counts condition per group [OK]

Common Mistakes:

Thinking SUM returns total amount instead of count
Ignoring GROUP BY effect
Confusing ELSE 0 with NULL

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given the table orders with columns category and amount, what does this query return?

Step 1: Analyze the CASE inside SUM

Step 2: Understand GROUP BY effect

Final Answer:

Quick Check:

Want More Practice?