$1.$ Complete the following chart using the data provided by Noah. Note that there should be a row for each unique job code. Sort the results by job code. Make sure to include all job codes, even if there are no responses for a job code in one of the years $($an error listed is OK if there is no data in that field$).$ Using a formula, round the per hour fields and the Gross pay difference field to two decimal places. Note the following: The $2015$ and $2016$ Gross pay columns should list the gross wages for each year. The average cost per hour is equal to the cost for that year divided by the number of hours for that year. The columns Hours difference and Gross pay difference should be computed by taking the $2016$ amounts and subtracting them from the $2015$ amounts $($i$.$e$.,$ positive amounts mean $2016$ was more than $2015)$ When saving your queries, name the final query with your complete answer as gry$\_$Part$3\_$Q$1\_$FINAL. If you use any queries to create your final query, name them as qry$\_$Part$3\_$Q$1\_$DESCRIPTION, where DESCRIPTION provides a brief, useful description of what you are doing in that query $20162016$ gross Job code Job description Gross pay $2015$ gross pay $2015$ hours $2015$ gross pay $2016$ hours gross pay pay per hour Hours difference Gross pay per hour difference per hour difference $123$ etc $2.$ Write a query to return the information listed in the chart below. Design the query so that the user is prompted to enter the job code and the results are only returned for that job code. Only return results for employees who have more than zero hours and zero wages in a job code for both $2015$ and $2016.$ Sort the query in ascending order by the Gross pay difference. Using a formula, round the per hour, Hours difference and Gross pay difference fields to two decimal places. Investigate the three job codes with the largest positive wage differences found in the previous query that had wages and hours for both $2015$ and $2016.2015$ Gross pay $2015$ hours $2015$ gross pay gross pay per hour $2016$ hours $2016$ gross pay $2016$ gross pay per hour Gross Hours pay difference difference per hour difference Job code $01010101$ Employee Employee number name $1234$ etc. $3.$ Write a memo to Noah about what you have learned. Make sure to include the tables above in the memo and any additional tables that you created. Discuss any discrepancies that you observed and make suggestions about what you recommend Noah should do next.