SELECT a.Nume, a.Prenume, a.Salariu, d.NumeDepartament FROM Angajati a
INNER JOIN Departamente d ON a.DepartamentID = d.DepartamentID
WHERE a.Salariu IN (SELECT MAX(a2.Salariu) FROM Angajati a2  WHERE a2.DepartamentID = a.DepartamentID GROUP BY a2.DepartamentID)
ORDER BY a.Salariu DESC;

SELECT a.Nume, a.Prenume, a.DataAngajarii, d.NumeDepartament FROM Angajati a
INNER JOIN Departamente d ON a.DepartamentID = d.DepartamentID
WHERE a.DataAngajarii IN (SELECT MAX(a2.DataAngajarii) FROM Angajati a2  WHERE a2.DepartamentID = a.DepartamentID GROUP BY a2.DepartamentID)
ORDER BY a.DataAngajarii DESC;