-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathqueries.sql
156 lines (141 loc) · 5.33 KB
/
queries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
sql_schema('/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/sum_NjNy_2019.csv','sum_NjNy_2019')
CREATE TABLE sum_NjNy_2019 (
DAY_OF_WEEK numeric,
FL_DATE varchar,
OP_CARRIER varchar,
OP_CARRIER_FL_NUM numeric,
ORIGIN varchar,
ORIGIN_CITY_NAME varchar,
DEST varchar,
DEST_CITY_NAME varchar,
CRS_DEP_TIME numeric,
DEP_TIME numeric,
DEP_DELAY numeric,
CRS_ARR_TIME numeric,
ARR_TIME numeric,
ARR_DELAY numeric,
CRS_ELAPSED_TIME numeric,
ACTUAL_ELAPSED_TIME numeric,
AIR_TIME numeric,
DISTANCE numeric,
CARRIER_DELAY numeric,
WEATHER_DELAY numeric,
NAS_DELAY numeric,
SECURITY_DELAY numeric,
LATE_AIRCRAFT_DELAY numeric,
DELAY varchar);
COPY sum_NjNy_2019
FROM '/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/sum_NjNy_2019.csv'
DELIMITER ','
CSV HEADER;
sql_schema('/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/june2019.csv','flights_june_2019')
CREATE TABLE flights_june_2019 (
YEAR numeric,
DAY_OF_WEEK numeric,
FL_DATE varchar,
OP_CARRIER varchar,
OP_CARRIER_FL_NUM numeric,
ORIGIN varchar,
ORIGIN_CITY_NAME varchar,
DEST varchar,
DEST_CITY_NAME varchar,
DEP_TIME numeric,
DEP_DELAY numeric,
ARR_TIME numeric,
ARR_DELAY numeric,
ACTUAL_ELAPSED_TIME numeric,
AIR_TIME numeric,
DISTANCE numeric,
CARRIER_DELAY numeric,
WEATHER_DELAY numeric,
NAS_DELAY numeric,
SECURITY_DELAY numeric,
LATE_AIRCRAFT_DELAY numeric,
Unnamed numeric);
COPY flights_june_2019
FROM '/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/june2019.csv'
DELIMITER ','
CSV HEADER;
sql_schema('/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/july2019.csv','flights_july_2019')
CREATE TABLE flights_july_2019 (
YEAR numeric,
DAY_OF_WEEK numeric,
FL_DATE varchar,
OP_CARRIER varchar,
OP_CARRIER_FL_NUM numeric,
ORIGIN varchar,
ORIGIN_CITY_NAME varchar,
DEST varchar,
DEST_CITY_NAME varchar,
DEP_TIME numeric,
DEP_DELAY numeric,
ARR_TIME numeric,
ARR_DELAY numeric,
ACTUAL_ELAPSED_TIME numeric,
AIR_TIME numeric,
DISTANCE numeric,
CARRIER_DELAY numeric,
WEATHER_DELAY numeric,
NAS_DELAY numeric,
SECURITY_DELAY numeric,
LATE_AIRCRAFT_DELAY numeric,
Unnamed numeric);
COPY flights_july_2019
FROM '/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/july2019.csv'
DELIMITER ','
CSV HEADER;
sql_schema('/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/aug2019.csv','flights_aug_2019')
CREATE TABLE flights_aug_2019 (
YEAR numeric,
DAY_OF_WEEK numeric,
FL_DATE varchar,
OP_CARRIER varchar,
OP_CARRIER_FL_NUM numeric,
ORIGIN varchar,
ORIGIN_CITY_NAME varchar,
DEST varchar,
DEST_CITY_NAME varchar,
DEP_TIME numeric,
DEP_DELAY numeric,
ARR_TIME numeric,
ARR_DELAY numeric,
ACTUAL_ELAPSED_TIME numeric,
AIR_TIME numeric,
DISTANCE numeric,
CARRIER_DELAY numeric,
WEATHER_DELAY numeric,
NAS_DELAY numeric,
SECURITY_DELAY numeric,
LATE_AIRCRAFT_DELAY numeric,
Unnamed numeric);
COPY flights_aug_2019
FROM '/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/aug2019.csv'
DELIMITER ','
CSV HEADER;
sql_schema('/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/sumfall_NjNy_2019.csv','sumfall_NjNY_2019')
CREATE TABLE sumfall_NjNY_2019 (
FL_DATE varchar,
OP_CARRIER varchar,
OP_CARRIER_FL_NUM numeric,
ORIGIN varchar,
DEST varchar,
DEP_TIME numeric,
DEP_DELAY numeric,
TAXI_OUT numeric,
WHEELS_OFF numeric,
WHEELS_ON numeric,
TAXI_IN numeric,
ARR_TIME numeric,
ARR_DELAY numeric,
ACTUAL_ELAPSED_TIME numeric,
AIR_TIME numeric,
DISTANCE numeric,
CARRIER_DELAY numeric,
WEATHER_DELAY numeric,
NAS_DELAY numeric,
SECURITY_DELAY numeric,
LATE_AIRCRAFT_DELAY numeric);
COPY sumfall_NjNY_2019
FROM '/Users/ridwan/Documents/DataScience/Metis/Metis_Projects/Data/flights/sumfall_NjNy_2019.csv'
DELIMITER ','
CSV HEADER;