FastPrepTop Ten Employee Salaries
Problems/Top Ten Employee Salaries

Top Ten Employee Salaries

Solytics Partners logoSolytics Partners● EasyNEW GRADONSITE INTERVIEW

Updated Nov 2026

QuestionConstraints

Problem statement

Source note: Reported in a Solytics Partners new-grad onsite interview. The report asks for the ten highest salaries from two DataFrames using Pandas. We chose the employee and salary schemas, the join key, the columns returned, how ties break, what happens to missing rows, and the limits.

The employees DataFrame contains employee identities, and the salaries DataFrame contains one current salary per employee.

Using Pandas, return the ten employees with the highest salaries. Return the columns employee_id, employee_name, and salary, ordered by salary descending and then employee ID ascending. If fewer than ten employees have salary rows, return all matched employees.

Table schema

Pandas

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.

ColumnTypeNullableDescription
employee_idPKIntegerNo—
employee_nameTextNo—

salaries

At most one current salary row per employee.

ColumnTypeNullableDescription
employee_idPKIntegerNo—
salaryIntegerNo—

Foreign key: employee_id → employees(employee_id)

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
employee_idIntegerNo—
employee_nameTextNo—
salaryIntegerNo—

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

Constraints

  • employees.employee_id and salaries.employee_id are unique.
  • Every row in salaries references an employee.
  • Salaries are non-negative integers.
  • Employees without a salary row are excluded.
  • Return at most ten rows with deterministic tie ordering.

Similar questions at other companies

  • Delete Duplicate Employee RecordsInfosys · ONSITE INTERVIEWInfosys interview questions
  • Records Created or Updated in a Time WindowPelatro · ONSITE INTERVIEW
  • Latest New JobSphere · ONSITE INTERVIEW
  • Employees Whose Manager Left the CompanyZS · ONSITE INTERVIEWZS interview questions
  • Employees Above Average SalaryJP Morgan Chase · ONSITE INTERVIEWJP Morgan Chase interview questions
  • Retrieve Every Student RecordLSEG · ONSITE INTERVIEWLSEG interview questions
  • Combine Winner and Loser NamesAmazon · ONSITE INTERVIEW
  • Conditionally Insert or Update RecordsKlaviyo · ONSITE INTERVIEWKlaviyo interview questions
  • Employees with Matching DepartmentsAMD · ONSITE INTERVIEWAMD interview questions
  • New-User Devices That Opened an AppMicrosoft · ONSITE INTERVIEWMicrosoft interview questions
See Solytics Partners hiring insights