BILETUL 29

BILETUL 29

bilet29.a - select ANUL from AEROPORT29 where NR_ZBORURI=(select max (NR_ZBORURI) from AEROPORT29);
bilet29.b - select TRASEU from AEROPORT29 where (LUNGIME_TRASEU in (select max(LUNGIME_TRASEU) from AEROPORT29 group by ANUL)) and (ANUL='2010'); bilet29.c - select PASAGERI from AEROPORT29 where (TRASEU ='Bucuresti-Timisoara')and(FIRMA='TAROM')and(ANUL='2009');