How should I practice Highest-Earning Employees By Department?

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

Is Highest-Earning Employees By Department 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

Highest-Earning Employees By Department

● Easy

JPMorgan ChaseFULLTIMEONSITE INTERVIEW

Problem statement

The table employees stores one row per employee, including that employee's department and salary.

For each department, find its highest salary. Return every employee who earns that department-highest salary, including all employees tied at the top.

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

What the interview report shared

The interview report listed a SQL task about the highest-earning employee at the department level.

employees
Column	Meaning
`employee_id`	Unique employee identifier
`employee_name`	Employee display name
`department_id`	Department identifier
`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	—
department_id	Integer	No	—
salary	Integer	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
department_id	Integer	No	—
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, department_id, and salary are non-null.
0 <= salary <= 10^9.