The Finance Department at Salt Lake City International Airport (SLC) is forecasting next year's budget for parking
Question:
The Finance Department at Salt Lake City International Airport (SLC) is forecasting next year's budget for parking lot snow plowing expenses. They would like to compare the total number of seats departing SLC for the upcoming winter months (November through April) to the same period in the 2015-16 winter season. You will need to connect to the TEST database and join the 'slcdeice' table and 'actype' table to sum the number of seats seats for each flight departing SLC during the November 2015 through April 2016 period. Submit the total number of seat departures for the period along with your SQL script language used to query the database. What is the total number of seats on aircraft departing SLC airport between November 2015 and April 2016?
Paste the MYSQL script you wrote to come up with your answer below.
Principles of Information Systems
ISBN: 978-0324665284
9th edition
Authors: Ralph M. Stair, George W. Reynolds