Question: Use SQL Query 1. List the airport code of origin and airport code of destination, the departure and arrival dates and times, the airline name,

Use SQL Query

1. List the airport code of origin and airport code of destination, the departure and arrival dates and times, the airline name, and the kind of plane (manufacturer and model together in a single column) for all flights that will occur in the month of March. This query should be written so that whenever it is run, it will *always* return only those flights which will occur in March, regardless of year. If any part of a flight occurs in March, it must be included. This means that is a flight takes off before midnight on February 28, and lands at its destination early on March 1, it will still be included. The same would go for flights that depart late on the last day of March but arrive in the early morning of April 1. Sort your results so that the flights that will occur at the end of March will be at the top, and the flights at the beginning will be at the bottom.

2. Write a query to list each Flight ID, its airport code of origin, destination, start and end dates and times, and then three columns showing the number of seats occupied (rounded up to the nearest whole seat) when the plane is 60% full, 75% full, and 95% full. Alias these three columns appropriately.

Use SQL Query 1. List the airport code of origin and airport code of destination, the departure and arrival dates and times, the airline name, and the kind of plane (manufacturer and model together in a single column) for all flights that will occur in the month of March. This query should be written so that whenever it is

Database Diagrams Tables System Tables FileTables dbo.Airlines dbo.Airports dbo.Flights dbo.planes 17Script for nd from SSMS 2 ESELECT TOP (1000) [AirlineID irlineName 4 FROM bol.[Airlines] 100 % Results Messages AirlineID AirlineName American Delta Southwest Airlines United Virgin Atlantic Frontier Airlines Frontier Airlines Frontier Airlines Script tor SelectTopNRows command from SSMS 2 SELECT TOP (1000) [AirportCode] , [AirportLocation] , [YearOpened] , [NumTerminals] 4 FROM [dbo]. [Airports] 100 % Results Messages AirportCode AirportLocation 1ATL 2 BOI 3 DFVW 4 IAH 5 JAX 6 JFK 7 LAS 8 LAX 9 MCO 10 MIA 11 ORD 12 PHL Atlanta, GA Boise, ID Dallas-Fort Worth, TX Houston, TX Jacksonville, FL New York, New York Las Vegas, NV Los Angeles, CA Orlando, FlL Miami, FL Chicago, IL Philadelphia, PA Pittsburgh, PA Seattle, WA San Francisco, CA Salt Lake City, UT YearOpened NumTeminals 1926 1936 1973 1957 1968 1943 1947 1928 1942 1945 1942 1927 1946 1944 1927 1933 10 12 10 4 13 PIT 4 14 SEA 15 SFO 16 SLC 1 ***Script for SelectTopNRows command from SSMS 2 ESELECT TOP (1000) [FlightID] , [PlaneID] [AirlineID] ,[AirportCodeOfDeparture] ,[AirportCodeofArrival] , [DepartureDateTime] ,[ArrivalDateTime] 9FROM [dbo]. [Flights] 100 % Messages FlightID PlanelD AirinelD AirportCodeOf Departure ArportCodeOf Amival DepartureDate Time Arival Date Time 11000 118 2 1001 111 3 1002 122 4 1003 112 5 1004 114 PIT LAS MIA ORD PHL MIA ! DFW 2018-12-23 06:28:00.000 2018-12-23 09:45:00.000 2019-04-24 18:50:00.000 2019-04-24 22:23:00.000 2018-12-29 17:46:00.000 2018-12-29 18:59:00.000 2018-12-31 16:21:00.000 2018-12-31 19:33:00.000 2019-02-23 11:53:00.000 2019-02-23 12:25:00.000 2019-01-01 11:43:00.000 2019-01-01 15:04:00.000 2019-04-09 12:41:00.000 2019-04-09 14:25:00.000 2019-03-20 12:48:00.000 2019-03-20 15:07:00.000 2019-01-06 05:31:00.000 2019-01-06 09:56:00.000 2019-01-26 22:23:00.000 2019-01-27 01:47:00.000 2018-12-04 11:16:00.000 2018-12-04 14:45:00.000 2018-11-04 02:58:00.000 2018-11-04 03:08:00.000 2019-03-22 07:00:00.000 2019-03-22 08:23:00.000 2019-04-17 11:16:00.000 2019-04-17 15:38:00.000 2018-11-14 05:18:00.000 2018-11-14 08:43:00.000 2018-12-20 14:31:00.000 2018-12-20 17:11:00.000 2019-03-13 20:09:00.000 2019-03-13 21:20:00.000 2018-11-30 14:46:00.000 2018-11-30 18:14:00.000 2018-11-26 01:22:00.000 2018-11-26 03:54:00.000 2019-02-25 10:22:00.000 2019-02-25 11:59:00.000 2019-01-23 05:58:00.000 2019-01-23 09:26:00.000 2019-02-08 20:56:00.000 2019-02-08 23:08:00.000 2019-02-24 04:44:00.000 2019-02-24 05:08:00.000 2019-02-18 12:07:00.000 2019-02-18 16:16:00.000 BOI SEA 6 1005 2 JAX SFO PHL ORD BOI 1006 101 8 1007 125 9 1008 123 10 1009 125 11 1010 127 12 1011 116 13 1012 127 14 1013 115 15 1014 110 16 1015 123 17 1016 105 18 1017 101 19 1018 118 20 1019 112 21 1020 102 22 1021 121 23 1022 120 24 1023 120 DFW SEA ORD SFO ORD LAS SEA SEA PHL DFW LAS JAX SEA SLC BOI SFO BOI AH SLC AH LAS SFO SLC DFW 1 /***Script for SelectTopNRows command from SSMS 2SELECT TOP (1000) [Plane!DJ , [Manufacturer] ,[Mode1Num] , [OriginalPurchaseDate] ,[LastServiceDate] , [AirlineID] , [NumSeats] 4 7 FROM [dbo]. [Planes] 100 % PlanelD Manufacturer ModelNum OniginalPurchaseDate Last ServiceDate AirlinelD NumSeats 787 Dreamliner 2014-10-10 2003-03-23 1999-11-24 2002-10-02 2000-04-16 2001-10-25 2009-12-02 2005-05-14 1999-10-20 2009-05-05 1999-11-25 2012-06-12 2014-12-01 2007-11-24 2000-08-31 2011-11-11 2008-06-27 2008-11-25 2013-03-27 2000-07-15 2001-12-05 2013-02-14 2008-08-21 2001-12-02 2008-02-18 2018-08-17 2018-08-26 2018-07-31 2018-06-20 2018-07-24 2018-05-03 2018-08-26 2018-03-21 2017-12-27 2018-08-20 2018-07-03 2018-06-17 2018-02-28 2018-06-07 2018-06-08 2018-09-01 2017-12-09 2018-08-27 2017-09-23 2018-04-13 2018-07-06 2018-08-16 2018-08-20 201806-16 2018-05-08 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 737-900 RJ-45 737-900 747-400 737-900 747-400 737-900 8 107 13 112 737-900 747-400 RJ-45 RJ-45 747-400 737-900 727-200 22 121 25 124

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The following are the tables of my database that I have already created in mysql. What I need is a query that will: 1.) List the airport code of origin and airport code of destination, the departure...

I need the mysql querry for this problem, that I cannot seem to get right. Below is the database structure. List the airport code of origin and airport code of destination, the departure and arrival...

An airline company is interested in implementing a database system to manipulate the flights that it organizes. The airline company has a certain number of airplanes. Each airplane has a unique code,...

Data base Steps to be done Step 1: Data Modeling - Create an ER diagram, Step 2: Map ER diagram into a relational model, Later: Step 3: Put the tables in the 3rd normal form, Step 4: Create your...

There are a few of the flight_info.csv pages Here's the main.py import airline, airport, flight airline_dict = {} airport_dict = {} date_dict = {} #Process CSV File #Queries def query1(): #Process...

Please help me the below questions. I was trying to do it, but I got stuck. Please give an explanation/comment as well on what you did. Thank you. Below is the screenshots of the tables and columns:...

1. List the flights that cost more than 800, reporting their ID, airport code, destination code, and fare. 2. What passengers do not have an airport in their hometown? List their names and hometown....

Project 3 Details: This project is based on eight tables (AIRPORT, FLIGHT, DEPARTURES, PASSENGER, RESERVATION, EQUIP_TYPE, PILOTS, and TICKET) that contain data about the Belle Airlines. Download and...

CUSTOMER EMAIL CUSTOMER FAX CUSTOMER PHONE CUSTOMER ID CUSTOMER ID CUSTOMER FAX COUNTRY CODE CUSTOMER FAX AREA CODE CUSTOMER FAX NUMBER CUSTOMER ID CUSTOMER PHONE COUNTRY CODE CUSTOMER PHONE AREA...

Your Great Aunt Mildred has been knitting for as long as you can remember. She's created scarves, blankets, hats, and even winter socks. She's currently thinking about turning her hobby into a full...

Please provide an argument for and an argument against. 3. This question studies how labor income has evolved over the past 50 years relative to GDP. a. Using FRED, acquire the following data series:...

You have calculated the pro forma net income for a new project to be 4 6 1 4 0

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Empowerment may only be appropriate in low uncertainty avoidance, individualistic and low power distance cultures, and where information and status are not protected.

6 They therefore need to work at the strategic level associated with change, adaptation and development and the operational level associated with the realism of budgetary constraints and vertical...

2 The control and use of power may be problematic. There is little formal power available to sanction members in the case of failure. Managers were selected irrespective of position in the hierarchy....