Show all flight numbers.
select flno from flight
Which of them are on aircraft Airbus A340-300?
select t1.flno from flight as t1 join aircraft as t2 on t1.aid = t2.aid where t2.name = "Airbus a340-300"