[Solved] Consider the table Employees with salaries:5000, 7000, NULL, 6000What does the query SELECT AVG(salary) FROM Employees WHERE salary > 5500; return? | SQL

SQL - Aggregate Functions

Consider the table Employees with salaries:
5000, 7000, NULL, 6000
What does the query SELECT AVG(salary) FROM Employees WHERE salary > 5500; return?

ANULL

B6000

C6500

D7000

Step-by-Step Solution

Solution:

Step 1: Filter salaries greater than 5500
Values are 7000 and 6000; NULL is ignored.
Step 2: Calculate average of filtered values
(7000 + 6000) / 2 = 13000 / 2 = 6500.
Final Answer:
6500 -> Option C
Quick Check:
AVG() with WHERE filters values = 6500 [OK]

Quick Trick: WHERE filters rows before AVG() calculation [OK]

Common Mistakes:

MISTAKES

Including NULL in average
Not applying WHERE filter before AVG()

Master "Aggregate Functions" 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 the table Employees with salaries:

Step 1: Filter salaries greater than 5500

Step 2: Calculate average of filtered values

Final Answer:

Quick Check:

Want More Practice?