#227 Employees with the Maximum Salary by Position

Companies:

GosUslugi

Themes:

SQLAggregationPractice

Find the employees who have the maximum salary for their position:

fio        | position    | salary
-----------|-------------|--------
Ivanov     | Developer   | 100000
Gorokhov   | Developer   | 120000
Petrov     | Developer   | 140000
Sidorov    | Tester      | 100000
Kuznetsov  | Tester      | 120000
Mikhailov  | Tester      | 150000
Antonov    | Developer   | 200000
Sukhoy     | Developer   | 100000
Mikoyan    | Developer   | 100000
Dzhugashvili | Director  | 300000
Beria      | Security    | 200000

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.