Hello, can someone please help me with this problem: Load the necessary column d

Question

Hello, can someone please help me with this problem:

Load the necessary column data into a MongoDB collection. 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 statements.

Use the following csv file for the data:

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

SQL Query for the Operations is as follows:

The query statement for achieving the above results are as follows:

SELECT AIRLINE_NAME , NO_FLIGHTS , TOTAL_PASSENGER_UPLIFTED FROM AIRLINES
WHERE TYPE_OF_OPERATION = PASSENGER &&
TOTAL_PASSENGERS_UPLIFTED > 247271;

Note: All the given columns are been taken from the above given linked file and the number 247271 is the total passengers uplifted by the Monarch Airlines in the given file.Hence, we have achieved the objective.

Please rate the answer if it helps....Thankyou

hope it helps...

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

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