Pergunta de entrevista da empresa SolarWinds

Find the highest and second highest salaries by department from a table (SQL)