Answer the following:

Assignment: Please post the following in the class dropbox NLT midnight, 4 Nov. 2018: 1. .sql file with SQL script that executed the requirements noted below 2. The Word document that contains the translation of the requirement to the SELECT statement that executes the requirements noted below 1. Use the schoolscheduledb database schema 2. Copy this assignment into a Word Document and provide the Translation, Cleanup, and SQlL that accomplishes the following requirements: a. "An organization on campus has requested a list of female students in particular states for potential support on a planned campaign affecting those particular states. The list should include female students from the states of Oregon and Washington. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 7 rows returned. Think predicate and logical operator." -b. "The chair of the department has requested a current list of all student majors in ascending order by major as currently in the database Make sure it looks exactly like the example output (at the back of this assignment). Hint: 18 rows returned. Check for secondary ordering. Table JOIN required." -c. "The dean is requesting a list of subjects taught on Monday only". Make sure it looks exactly like the example output (at the back of this assignment). Hint: A filter using predicate IN with an inner query. 36 rows returned. Very similar to Assignment Procedure Video 2. 4. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 5. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirement that are provided in the output grid, 6. As noted above, post both the Word document with the translation statements and the SQL (sql) file that executes the required query. Both files (only 2 files submitted) must be submitted into the dropbox by the due date to receive full credit. Note that the one (1) sql file will have all queries (sql) contained in it. There should not be more than one sql file posted. 7. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below a. Translation: TRANSLATION