SELECT A.*
FROM AVION A INNER JOIN LET L
ON A.AVIONID = L.AVIONID
INNER JOIN LINIJA LIN
ON LIN.LINIJAID=L.LINIJAID
INNER JOIN AERODROM POL
ON LIN.POLAZNI_AERO=POL.AEROID
INNER JOIN AERODROM DOL
ON LIN.ODREDISNI_AERO=DOL.AEROID
WHERE L.DATUM_VREME='2004-08-16' AND A.BROJ_SEDISTA>200 AND DOL.MESTO NOT IN ('New York','London')

SELECT L.DATUM_VREME, L.LINIJAID, POL.NAZIV, DOL.NAZIV
FROM LET L INNER JOIN LINIJA LIN
ON LIN.LINIJAID=L.LINIJAID
INNER JOIN AERODROM POL
ON LIN.POLAZNI_AERO=POL.AEROID
INNER JOIN AERODROM DOL
ON LIN.ODREDISNI_AERO=DOL.AEROID
WHERE POL.DRZAVA='Svajcarska' AND DOL.DRZAVA='Spanija' AND EXTRACT(YEAR FROM L.DATUM_VREME) = EXTRACT(YEAR FROM CURRENT_DATE) AND EXTRACT(MONTH FROM L.DATUM_VREME) IN (4,5,6)
ORDER BY L.DATUM_VREME ASC;