2.(4 points Each) Specify the following queries in SQL (provide the SQL commands) on the following database schema (No result is required). 1) Retrieve the name, class and major for students who has taken courses in 2008. 2) Retrieve the name and transcript of each student majoring in CS. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. 3) Retrieve the course taught by King regarding the course name, course number and in which semester and year it is offered. 4) Retrieve the name of students who has taken a course requiring another course that is from the MATH department as prerequisite. 17 Database SECTION 102 MATH2410 CS1310 C53380 119 GRADE REPORT Shudent number PREREQUISITE