Basic SQL question

and flights as follows Consider the "airline'' database containing tables countries cities, aircraft countries Country Code Country Name AUS Australia IND Indonesia alaysia MLY NZL New Zealand USA United States of America cities City Code City Name Country Code AUS ADL Adelaide Auckland NZL Brisbane AUS BNE Canberra AUS CBR IND Jakarta CGK USA Honolulu HNL Los Angeles USA Melbourne AUS MEL San Francisco USA. SFO Sydney SYD AUS BRI Brisbane USA