[Solved] Consider a table transactions with columns store and sales_amount. What does this query return?SELECT store, AVG(sales_amount) AS avg_sales FROM transactions GROUP BY store ORDER BY avg_sales DESC; | SQL

SQL - GROUP BY and HAVING

Consider a table transactions with columns store and sales_amount. What does this query return?

SELECT store, AVG(sales_amount) AS avg_sales FROM transactions GROUP BY store ORDER BY avg_sales DESC;

AAverage sales per store, sorted from highest to lowest average

BTotal sales per store, sorted alphabetically by store

CAll transactions sorted by sales_amount descending

DStores with sales above average, sorted ascending

Step-by-Step Solution

Solution:

Step 1: Analyze SELECT and GROUP BY
The query groups rows by store and calculates the average sales_amount for each group.
Step 2: Analyze ORDER BY
The results are ordered by avg_sales in descending order, showing stores with highest average sales first.
Final Answer:
Average sales per store, sorted from highest to lowest average -> Option A
Quick Check:
AVG aggregation with descending order [OK]

Quick Trick: GROUP BY aggregates, ORDER BY sorts aggregates [OK]

Common Mistakes:

MISTAKES

Confusing AVG with SUM
Assuming ORDER BY sorts individual rows
Ignoring GROUP BY effect

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider a table transactions with columns store and sales_amount. What does this query return?

Step 1: Analyze SELECT and GROUP BY

Step 2: Analyze ORDER BY

Final Answer:

Quick Check:

Want More Practice?