Question 27 (90 points) Please consider the following relational database tables. Primary keys are underlined, and foreign keys are marked with an asterisk. - Date format: MM/DD/YYYY, for example, 09/29/2023. Questions: Provide the appropriate SQL statements necessary to answer the queries that follow. a) Write an SQL query to list the employee's name, item number, order date, and unit price of the item for employees with a salary below $75,000. (20 points) b) Write an SQL query to show the total dollar amount of purchase orders made to each vendor in January 2023, including their names and addresses. Present the query results with the vendor names in reverse alphabetical order. ( 30 points) c) Write an SQL query to display the average salary of employees by grade, rounded to the 2nd decimal place, for those paid in October 2023. Additionally, the query should include the order date, the total purchase amount for each order date, and the number of employees for each order date. The results should be presented in alphabetical order based on employees' names and addresses. ( 40 points; Rename your fields if necessary.)