Sobes.tech
Senior

-- There are tables with the following structure Employee id (PK) name salary dep_id (FK department.id) Department id (PK) name -- Write a query that returns a list of all department names with the maximum salary in each department.