[Solved] Given the table orders with columns customer_id and total, what will this query return?SELECT customer_id, SUM(total) AS total_spent FROM orders GROUP BY customer_id HAVING SUM(total) > 1000; | SQL

SQL - GROUP BY and HAVING

Given the table orders with columns customer_id and total, what will this query return?

SELECT customer_id, SUM(total) AS total_spent FROM orders GROUP BY customer_id HAVING SUM(total) > 1000;

AAll customers with total orders less than or equal to 1000

BAll orders with total greater than 1000

CAll customers with total orders greater than 1000

DSyntax error due to HAVING clause

Step-by-Step Solution

Solution:

Step 1: Understand the GROUP BY and aggregation
The query groups orders by customer_id and sums their total orders.
Step 2: Apply HAVING filter
HAVING SUM(total) > 1000 filters groups where total spent is more than 1000.
Final Answer:
All customers with total orders greater than 1000 -> Option C
Quick Check:
HAVING filters groups with sum > 1000 = B [OK]

Quick Trick: HAVING filters groups based on aggregate conditions [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table orders with columns customer_id and total, what will this query return?