Emails us- support@assignmnetanswers.com. Call US

Assignment help 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 average price paid for all purchased flights for each passenger who has

flown more than 100,000 miles.

b. List the names, miles and destination City Name for frequent flyers who have flown to cities

(Destinations) with population equal to the number of miles in their frequent flyer account.

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.