Airport SQL Reports

An Airplane Online Ticket Broker Company has asked you to utilise a Business Intelligence (BI) process for analysing data and presenting actionable information to help executives, managers and other corporate end users make informed business decisions.

It encompasses a wide variety of tools, applications and methodologies that enable organizations to collect data from various sources, develop and run queries against that data, and create reports, dashboards and data visualizations to make the analytical results available to corporate decision-makers. They have asked you to extract some reports for BI purposes and also implement some changes.

To this purpose, the data of the following two tables (Airport & Flight) has been made available to you:

AIRPORT:

FLIGHT:

TASK:

Provide the proper SQL code in order to create the following reports and changes:

• Create a report listing all airports which do not have any incoming flights.
• Create a report of all flights arriving to Liverpool with their flight number departure origin (the name of the airport) and departure time.
• Create a new flight from Luton to Southampton departing at 17:30 with flight number 271.
• Correct the time of flight number 243 from 10:30 to 10:35.
• Create a report that contains the number of departing flights for each airport.