FilesExpand file tree

main

/

sql6-1.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (18 loc) · 471 Bytes

main

/

sql6-1.sql

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (18 loc) · 471 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

-- +++++++++++++++++++++++++++++++++++++++++++++++++++++

-- Description: Which of the three airports had the most

-- flights?

-- Course: Intro. to Database

-- Author: Quinlan, J.

-- Date: 2023-04-13

-- +++++++++++++++++++++++++++++++++++++++++++++++++++++

use nycFlights;

SELECT

origin AS Airport

FROM

(SELECT

origin, COUNT(fid) AS NumFlights

FROM

Flights

GROUP BY origin

ORDER BY NumFlights DESC) AS X

LIMIT 1;