Pergunta de entrevista da empresa Tenet Healthcare

To write a SQL query finding out the highest salary of employee within each department