Create one .sql file with SQL queries that executes the requirements noted below. Make sure you have comments in your sql in the beginning providing your name, course/course section, and CWID. (points deducted for not having this comment) 1. Use the salesordersDB or schoolschedDB database schema as appropriate. 2. Translate the requirements below into a SQL query that accomplishes the following: -a. Based on a university campaign, the dean has requested a list of the names of all students with their hometown/resident cities. She requested the list be sorted by city. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 18 rows returned. -b. Management wants to see the current inventory value for products with retail prices of $150.00 or more. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 10 rows returned. 3. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 4. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirements that are provided in the output grid. 5. As noted above, post the SQL (sql) file that executes the required query. The sql file (only 1 file submitted) must be posted in the dropbox by the due date to receive full credit. Note that the one (1) sql file will have both queries (sql) contained in it. There should not be more than one sql file posted. Only one sql file will be graded. Any other sql files will not be reviewed. 6. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below.