[Solved] What result does this query produce on the transactions table with columns store and sales?SELECT store, SUM(sales) FROM transactions GROUP BY store HAVING SUM(sales) > 1000; | SQL

SQL - GROUP BY and HAVING

What result does this query produce on the transactions table with columns store and sales?

SELECT store, SUM(sales) FROM transactions GROUP BY store HAVING SUM(sales) > 1000;

AStores with total sales less than or equal to 1000

BStores with total sales greater than 1000

CAll stores regardless of sales

DStores with exactly 1000 total sales

Step-by-Step Solution

Solution:

Step 1: Group data by store
The query groups rows by the store column.
Step 2: Calculate total sales per store
It sums the sales for each store.
Step 3: Filter groups with HAVING
The HAVING clause keeps only stores where the sum of sales is greater than 1000.
Final Answer:
Stores with total sales greater than 1000 -> Option B
Quick Check:
HAVING filters groups by aggregate conditions [OK]

Quick Trick: HAVING filters groups after aggregation [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What result does this query produce on the transactions table with columns store and sales?