6.12. Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the names of all senior students majoring in "es" (computer science) b. Retrieve the names of all courses taught by Professor King in 2007 and 2008 c. For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section. d. Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number credit hours , semester. year, and grade for each course completed by the student. Class STUDENT Name Smith Brown Student number 17 B 1 Major CS CS 2 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course_number Credit hours Department CS1310 4 CS CS3320 4 CS MATH2410 3 MATH CS3380 | CS Year 07 SECTION Section identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Semester Fall Fall Spring Fall Fall 07 08 Instructor King Anderson Knuth Chang Anderson Stone 08 08 OB Fall GRADE REPORT Student number 17 Grade B 17 Section identifier 112 119 85 92 8 8 A B B 8 102 135 A PREREQUISITE Course number CS3380 CS3380 CS3320 that stores course Prerequisite number CS3320 MATH2410 CS1310