Identify the regular customers to provide offers, analyse the busiest route which helps to increase the number of aircraft required and prepare an analysis to determine the ticket sales details. This will ensure that the company improves its operability and becomes more customer-centric and a favourable choice for air travel.
- Customer : [customer_id], [first_name], [last_name], [date_of_birth], [gender]
- passengers_on_flights : [aircraft_id], [route_id], [customer_id], [depart], [arrival], [seat_num], [class_id], [travel_date], [flight_num]
- ticket_details: [p_date], [customer_id], [aircraft_id], [class_id], [no_of_tickets], [a_code], [price_per_ticket], [brand]
- routes : [route_id], [flight_num], [origin_airport], [destination_airport], [aircraft_id], [distance_miles]
