[Solved] Identify the error in this SQL query:SELECT SUM(price), AVG(price) FROM sales GROUP BY category; — Ans: Missing GROUP BY column in SELECT clause | SQL

SQL - Aggregate Functions

Identify the error in this SQL query:

SELECT SUM(price), AVG(price) FROM sales GROUP BY category;

ANo error, query is correct

BCannot use SUM and AVG together

CMissing GROUP BY column in SELECT clause

DGROUP BY should be after WHERE clause

Step-by-Step Solution

Solution:

Step 1: Check GROUP BY usage
When using GROUP BY category, category must appear in SELECT to show groups.
Step 2: Identify missing column
Query selects only aggregates but misses category column, causing error or unexpected output.
Final Answer:
Missing GROUP BY column in SELECT clause -> Option C
Quick Check:
GROUP BY columns must appear in SELECT [OK]

Quick Trick: Include GROUP BY columns in SELECT list [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL query: