1. .sql file with SQL script that executed the requirementsnoted below
2. The Word document that contains the translation of therequirement to the SELECT statement that executes the requirementsnoted below
1. Use the schoolscheduledb database schema
2. Copy this assignment into a Word Document and provide theTranslation, Cleanup, and SQL that accomplishes the followingrequirements:
– a. “The Dean has received a request from the registrarto provide (for statistical purposes) the marital status of allstudents. This output will provide initial statistical data forfocusing email specific to each marital status group.”. Make sureit looks exactly like the example output (at the back of thisassignment). Hint: CASE
OR
OR