How should I practice Employees Above Average Salary?

Start by reading the full statement, solve the visible examples, then compare the pattern against related JPMorgan Chase onsite interview problems in FastPrep.

Is Employees Above Average Salary associated with JPMorgan Chase?

FastPrep tags this as a JPMorgan Chase onsite interview coding practice problem when the problem catalog has that company and stage context.

Problem · Database

Employees Above Average Salary

● Easy

JPMorgan ChaseFULLTIMEONSITE INTERVIEW

Problem statement

The table employees stores one row per employee and their salary.

Compute the average salary across all rows. Return every employee whose salary is strictly greater than that overall average.

Return employee_id, employee_name, and salary. Order rows by salary descending, then employee_id ascending.

What the interview report shared

The interview report listed a SQL task about employees whose salary is greater than the average salary.

employees
Column	Meaning
`employee_id`	Unique employee identifier
`employee_name`	Employee display name
`salary`	Employee salary

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

employees

One row per employee.

Column	Type	Nullable	Description
employee_idPK	Integer	No	—
employee_name	Text	No	—
salary	Integer	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
employee_id	Integer	No	—
employee_name	Text	No	—
salary	Integer	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

The employees table has between 1 and 10^5 rows.
employee_id is unique and non-null.
employee_name and salary are non-null.
0 <= salary <= 10^9.