Create the queries based on the tables given.

Courses description (Not Null) Fundamentals of Computer Svs Software Engineering I Computer Programming I Introduction to Algorithms Operating Systems Software Design Advanced Database course id level instructor semester (PK) (Not Null) (FK) ugrad ugrad ugrad grad grad grad Spring 2018 Spring 2018 Spring 2018 Fall 2017 Fall 2017 Spring 2017 Spring 2017 4 uery 1Update the Courses table by adding another column as shown above Query 2Retrieve all the courses (description) open in year 2018 uerv 3 List the name(s) of all the graduate coursels) taught by Steven Garden Query 4List the name(s) of instructor(s) who taught course(s) in Spring 2017 uerv 5 Retrieve all the courses (as well as grades) Alice Wood has taken, ordered by grades Query 7List the names and grades of the students who take the course "Fundamentals of Query 8List the name(s) of the faculties who offer(s) at least one graduate course and is (are) Query9List the name(s) of the student(s) who get(s) grade B for at least one undergraduate Query 10List the name(s) of the student(s) and the highest grade for each student. (ASCII uerv 6 List the name(s) of the faculties who offer(s) more than one courses Computer Sys,", ordered by grades born after 1979 course