CREATE TABLE FLIGHTS(fid INT PRIMARY KEY, year INT, month_id INT, day_of_month INT, day_of_week_id INT, carrier_id VARCHAR(3), flight_num INT, origin_city VARCHAR(34), origin_state VARCHAR(47), dest_city VARCHAR(34), dest_state VARCHAR(46), departure_delay DOUBLE, taxi_out DOUBLE, arrival_delay DOUBLE, canceled INT, actual_time DOUBLE, distance DOUBLE, capacity INT, price double, FOREIGN KEY (carrier_id) REFERENCES Carriers(cid),FOREIGN KEY (month_id) REFERENCES Months(mid),FOREIGN KEY (day_of_week_id) REFERENCES Weekdays(did)); CREATE TABLE CARRIERS(cid VARCHAR(7) PRIMARY KEY, name VARCHAR(83));
CREATE TABLE MONTHS(mid INT PRIMARY KEY, month VARCHAR(9));
CREATE TABLE WEEKDAYS(did INT PRIMARY KEY, day_of_week VARCHAR(9));
Note: For the questions below, you should be able to write queries that do not contain any subqueries. Please use joins where appropriate
List the distinct flight numbers of all flights from Seattle to Boston by Alaska Airlines Inc. on Mondays. Also notice that, in the database, the city names include the state. So Seattle appears as Seattle WA. Please use the flight_num column instead of fid. Name the output column flight_num. [Hint: Output relation cardinality: 3 rows]