[Solved] What will be the output of this query on table orders with column price?SELECT COUNT(price), SUM(price), AVG(price) FROM orders WHERE price > 100; | SQL

SQL - Aggregate Functions

What will be the output of this query on table orders with column price?

SELECT COUNT(price), SUM(price), AVG(price) FROM orders WHERE price > 100;

ACount, sum, and average of all prices including those ≤ 100

BOnly count of prices greater than 100

CSyntax error due to missing GROUP BY

DCount, sum, and average of prices greater than 100

Step-by-Step Solution

Solution:

Step 1: Understand WHERE clause effect
WHERE price > 100 filters rows before aggregation.
Step 2: Aggregates apply on filtered rows
COUNT, SUM, AVG calculate only on prices > 100.
Final Answer:
Count, sum, and average of prices greater than 100 -> Option D
Quick Check:
WHERE filters rows before aggregates [OK]

Quick Trick: WHERE filters rows before aggregates run [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query on table orders with column price?