SELECT DISTINCT pasazer.nazwisko, ilot.data, ilot.cena
FROM ilot
INNER JOIN pasazer_ilot ON ilot.nriLotu=pasazer_ilot.nriLotu
INNER JOIN pasazer ON pasazer_ilot.idPasazera=pasazer.idPasazera
WHERE ilot.nrLotu=10
ORDER BY ilot.data DESC, pasazer.nazwisko ASC