Scribd
Upload
3 views1 page

SQL Commands for Flight Data Analysis

Uploaded by

VIII11-09 BISWOSTEEKA SAHA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

SQL Commands for Flight Data Analysis

Uploaded by

VIII11-09 BISWOSTEEKA SAHA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

2. Consider the table FLIGHT given below.

Write commands in SQL for (i) to (iv) and output for (v)
to (vii). (7)

(i) Display details of all flights starting from Delhi.


(ii) Display details of flights that have more than 4 number of flights operating.
(iii) Display flight codes, starting place, destination, number of flights in descending order of
number of flights.
(iv) Display destinations along with flight destinations starting with ‘A’.
(v) SELECT MAX(NO_FLIGHTS) FROM FLIGHT;
(vi) SELECT DISTINCT(NO_STOPS) FROM FLIGHT;
(vii) SELECT START, COUNT(*) FROM FLIGHT GROUP BY Start;

You might also like