PROJECT

ProjectIDNameCityStateStartDateBudgetStatus1A LincolnNE2022-01-20470000In-progress2BColumbiaMO2022-08-15860000In-progress3C SeattleWA2022-01-01139000Cancelled4D Little RockAR2022-04-25768000In-progress5ESpringfieldMO2023-11-10650000In-progress6F DenverCO2022-08-20195000In-progress7GOmahaNE2022-07-30450000In-progress8HTulsaOK2021-01-20118900Completed9IConwayAR2021-06-12123000Completed10JLittle RockAR2023-03-22100000In-progress

Requirements)

• Write SQL statements to answer the questions on the next page. You dont have to create the PROJECT table in MS Access. With the given information (table and data above), you can write SQL statements (i.e., SELELCT statements). I am sure you know how to write SQL statements now. You learned it from the MS Access SQL lab.

• Write the SQL statements in a Word document and turn it in for grading via the submission link I have created in the Assignment 2 folder. You dont have to include the outcome table. I just want the SQL statement for each question for grading.

Questions

1. Write SQL statement to list all columns from the project table.

2. Write SQL statement to list the ID and name of the project whose budget is greater than 200000 and less than 300000.

3. Write SQL statement to list the ID, name, and start date of the project located in Little Rock, AR.

4. Write SQL statement to list ID and name of the completed project.

5. Write SQL statement to list the name, city and state of the project that has been completed or is in-progress.

6. Write SQL statement to list the status and number (i.e., how many) of project for each status.

7. Write SQL statement to list the number (i.e., how many) of projects in progress located in Missouri (MO).

8. Write SQL statement to list the state and the largest project budget in each state.

9. Write SQL statement to list the state and the average budget of the project which started before 2023 for each state.

10. Write SQL statement to list the ID, name and start date of the project which started after 2021. Arrange the query outcome by the start date so that the later start date comes first.