1.Start SQL*Plus

2.Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables:

Airport(Airport, AName, CheckIN, Resvtns, FlightInfo)

Route(RouteNo, RDescription)

Fares(FareType, Fdescription, Conditions)

Tariff(RouteNo , FareType, Price)

Aircraft(AircraftType, ADescription, NoSeats)

Flight(FlightNo, FromAirport, ToAirport, DepTime, ArrTime, Service, AircraftType, RouteNo)

Passenger(Pid, Name, Address, TelNo)

Ticket(TicketNo, TicketDate, PID)

Itinerary(TicketNo, FlightNo, LegNo, FlightDate, FareType)

3.List the code of those airports that do not have any flights with scheduled departure time between 1:00 am (0100) and 7:30am (0730).

4.List the names of the passengers with at least two tickets which cost over 180 each.