Consider the airline database containing tables countries, cities, aircraft and flights as follows:

countries:

CountryCode	CountryName
AUS	Australia
IND	Indonesia
MLY	Malaysia
NZL	New Zealand
USA	United States of America

cities:

CityCode	CityName	CountryCode
ADL	Adelaide	AUS
AKL	Auckland	NZL
BNE	Brisbane	AUS
CBR	Canberra	AUS
CGK	Jakarta	IND
HNL	Honolulu	USA
LAX	Los Angeles	USA
MEL	Melbourne	AUS
SFO	San Francisco	USA
SYD	Sydney	AUS
BRI	Brisbane	USA

aircraft:

AircraftType	AircraftDescription	SeatingCapacity
AB3	Airbus A300	250
D10	McDonnel Douglas DC10	150
727	Boeing 727	150
737	Boeing 737	120
74L	Boeing 747SP	260
743	Boeing 747-338	420
744	Boeing 747-438	420
757	Boeing 757	150
767	Boeing 767	260

flights:

FlightNum	FromCityCode	ToCityCode	SeatsRemaining	AircraftType
1	BNE	SYD	10	AB3
2	SYD	CBR	20	727
3	SYD	MEL	30	757
4	SYD	AKL	40	D10
5	BNE	CGK	50	757
6	BNE	LAX	60	74L
7	SYD	HNL	70	767
8	HNL	SFO	80	767
9	SYD	LAX	90	744
10	SYD	BNE	100	AB3

Now, imagine that you want to produce a list that describes all aircraft types that fly out of Brisbane. Which of the following database queries will produce the following result set?

AircraftDescription

Airbus A300

Boeing 757

Boeing 747SP

		SELECT DISTINCT AircraftDescription FROM aircraft, flights WHERE FromCityCode = 'BNE' AND ToCityCode != 'BNE'
		SELECT AircraftDescription FROM aircraft, flights WHERE flights.AircraftType = aircraft.AircraftType AND FromCityCode = 'BNE'
		SELECT * FROM aircraft, flights WHERE flights.AircraftType = aircraft.AircraftType AND ToCityCode = 'BNE'
		SELECT AircraftDescription FROM aircraft, flights, cities WHERE CityName = 'Brisbane' AND FromCityCode = 'BNE'
		SELECT AircraftDescription FROM aircraft, flights WHERE FromCityCode = 'BNE'
		SELECT DISTINCT AircraftDescription FROM aircraft, flights WHERE FromCityCode = 'BNE'