ORDER per due tabelle

[IRide]

select a.cognome, a.nome
from corsi as c
left join alunni as a on a.idalunni = c.idalunni
left join classe as l on l.idclasse = c.idclasse
order by l.classe, a.cognome, a.nome