Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Employees Above Company Average

Easy Subqueries

List the names of employees whose salary is above the average salary of the whole company, ordered by name.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), salary INT)

Sample data

id | name | salary
1 | Alice | 70000
2 | Bob | 40000
3 | Carol | 55000
4 | Dan | 35000

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.