Hello, can someone please help me with this: Load the necessary column data into

Question

Hello, can someone please help me with this:

Load the necessary column data into a MySQL table. Write query statements to display airline names, number of flights, and total number of passengers uplifted by those airlines, of which the total number of passengers uplifted is more than that of Monarch Airlines. Submit a screenshot showing the results returned by the query statement.

You will need the csv file which can be downloaded at: http://www.caa.co.uk/uploadedFiles/CAA/Content/Standard_Content/Data_and_analysis/Datasets/Airline_data/2017/January/Table_03_All_Services.csv

Thanks so much

Explanation / Answer

select airline_name, no_flights, total_passengers from table_one where ( count (select * from table_one group by airline_name) ) > ( count(select * from table_one where airline_name="MONARCH AIRLINES") );

Before the where clause it select the required attributes from table_one (the table containing the data) after the where there are 2 counts which are being compared. The first count refers to the all the airlines being grouped by there names and second one is the count of passangers on the MONARCH AIRLINES.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.