Employees Paid More Than Their Manager
Solve this the way you would in the interview: out loud, on a timer, with an AI interviewer asking follow-ups while you code. You get a scored report at the end.
Practice this as a mock interviewFree to start, no account neededProblem
Table employees:
id INTEGER primary key
name TEXT
salary INTEGER
manager_id INTEGER the id of another row in this table, or NULL for someone with no manager
Return every employee whose salary is strictly higher than their manager's salary.
Columns, in this order: employee name, employee salary, manager name.
Order by employee name, ascending.
Examples
Constraints
- An employee with no manager is never in the result.
- Equal pay does not count.
What the interviewer grades
A correct solution is one of five scores. The report also grades problem understanding (did you clarify inputs and edge cases before coding), problem solving, communication while you work, code quality, and testing. See a sample report, or read up on the pattern in the lessons.