Answered>Order 3109
Using the following tables structure, please provide the SQL script to answer the query that follows. The primary key is underlined and the foreign key is shown in bold. Frequent_flier(Name, ffID, City, Street, zip, miles) Reservation(ResID, ffID, flightID, flightDate, class, price, seatID) Flight(FlightID, OriginCityName, DestinationCityName, DepTime, ArrTime, equipID) City(CityName, Population) a. List the ffID, and […]