CS 200 Assignment 8 — SQLDue Wednesday March 13th2019, 11:59 pm1. Download ForAssign8.docxand SampleDB_Diagram.pdffrom Assignments > Assignment 8 > Assignment Fileson Learn. Rename ForAssign8.docxto username_A8.docxusername1_username2_A8.docxif you are working with a partner. Using MS Wordinsert your input and/or output after each sub-question. Please format your answerswith the following styles provided in ForAssign8.docx.Use the style AnswerTop for the first line of your statement e.g. SELECT.Use the styleAnswer for the lines between AnswerTop and AnswerBot.Use the styleAnswerBot for the last line of your statement.Use the style SQL_Outputfor tabular SQL output, where requested. You do not need to create an MS Word table. Dba dba DbaThese styles are already in ForAssign8.docx.Approximately 7% of the marks for this question are reserved for proper formatting of your answer within ForAssign8.docx.[75%] In InteractiveSQLcreate the appropriate statements to answer the queries below, based on the database described in SampleDB_Diagram.pdfa)What SQL statement would you use to list the courses known to the database?or , :Select Course From Courseb) What SQL statement would you use to list the student numbers of people taking Algebra?c)What SQL statement would you use to list the courses that have assignments due on Oct. 18, 1986, with their respective assignment numbers, and ordered by course?