FunctionRacerProblemsRace

Above the Average

MediumSQLSQLite

Return the name and salary of everyone who earns more than the average salary of the whole table. Rows may come in any order.

Example 1

employees
idnamesalary
1Ada3000
2Ben4000
3Cy5000
returns
namesalary
Cy5000

Constraints

Race itor take your time

Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.

More SQL problems