Who beats the average?

Question

Accepted Answer

The subquery AVG(salary) = (90000+75000+82000)/3 = 82333.33. The outer query keeps employees whose salary exceeds that average. Only Alice (90000) qualifies. Carol (82000) is below the average, Bob (75000) is well below. A subquery in WHERE that returns a single value is called a scalar subquery.