QUESTION NO.3: MANDATORY OPTIONAL/O Boxts (5 POINTS) Given the following database sample instance, write the following SQL queries: (CL03) Retrieve the course names of all the courses that offered by CS department (1 pts) Student Name Smith Brown Retrieve the names of all courses taught during fall of (year) 08 along with the names of the instructors. (2 pts) Student number Class 17 1 8 2 Major CS CS Department CS Retrieve the name and transcript of each junior student (class 1) majoring in Computer Science (CS). A transcript includes course names, course numbers, semester, year and grade for each course completed by the student. (2 pts) Course Course name Course number Credit hours Intro to CS1310 4 computers Data Structure CS3320 4 Discrete Math MATH2410 3 Database CS3380 3 CS MATH CS Section Section number Course number. Semester 85 MATH2410 FALL 92 CS1310 FALL 102 CS3320 SPRING 112 MATH2410 FALL 119 CS1310 FALL 135 CS3380 FALL Year 07 07 08 08 08 08 Instructor KING Anderson Knuth Chang Anderson Stone Grade. Report Student number 17 17 8 8 8 8 Section identifier 112 119 85 92 102 135 Course number MATH2410 CS1310 MATH2410 CS1310 CS3320 CS3380 Grade B B IA Prerequisite Course number. CS3380 CS3380 CS3320 Prerequisite CS3320 MATH2410 CS1310