CS 200 Assignment 8 — SQL1. Copy the Assignment File : Assign8.doc to your Documents folder rename yourfile yHC_Assignment8_Q1.docor (yHC1_yHC2_Assignment8_q1.docif you are working inpair). Using MS Word, insert your input and/or output after each sub-question below.Please format your answerswith the styles AnswerTop, Answer, AnswerBot, and SQL_Output(for tabular SQL output, where requested), which are already in Assign8.doc.Approximately 7% of the marks for this question are reserved forproper formatting of your answer within Assign8.doc.[75%] In InteractiveSQL create the appropriate statements to answer the queries below:a)What SQL statement would you use to list the courses known to the database?b)What SQL statement would you use to list the student numbersof people taking Biology? Note that the courses are stored with their course codes, c)What SQL statement would you use to list the student numbers and namesofstudents taking Biology, ordered by surname?