SELECT s.nume, c.titlu, sa.nr_locuri
FROM Student S
INNER JOIN contract con ON s.sid=con.sid
INNER JOIN curs c ON con.cid = c.cid
INNER JOIN sala sa ON c.sala = sa.cods
WHERE sa.nr_locuri <200
ORDER BY extract(YEAR FROM s.datan),s.nume