SELECT INITCAP(w.nazwa) nazwa, o.plec, TO_CHAR(z.od,'DD/MM/YYYY') data_zatr
FROM Wydzialy w JOIN Zatrudnienia z ON w.id_w = z.id_w JOIN Osoby o ON z.id_os = o.id_os
WHERE z.do IS NULL AND z.od =
      (SELECT MAX(z1.od)
      FROM Wydzialy w1 JOIN Zatrudnienia z1 ON w1.id_w = z1.id_w JOIN Osoby o ON z1.id_os = o.id_os
      WHERE w.id_w = w1.id_w AND z1.do IS NULL);