Styles QUESTION NO. 3: MANDATORY/OPTIONAL / BONUS (5 POINTS) Given the following database sample instance, write the following SQL queries: (CLO 3) Student Name Smith Brown Student number Class 17 1 8 2 Major CS CS Course Course name redit hours Course number CS1310 Department CS Intro to 4 computers Data Structure 4 CS CS3320 MATH2410 CS3380 Discrete Math Database 3 MATH CS 3 Section Section number 85 92 102 112 119 135 Course number MATH2410 CS1310 CS3320 MATH2410 CS1310 CS3380 Semester FALL FALL SPRING FALL FALL FALL Year 07 07 08 Instructor KING Anderson Knuth Chang Anderson Stone 08 08 08 * Grade Report Student number 17 Section identifier 112 Course number MATH2410 Grade B. Prerequisite Course number CS3380 CS3380 CS3320 Prerequisite CS3320 MATH2410 CS1310 Retrieve the course names of all the courses that offered by CS department (1 pts) Retrieve the names of all courses taught during fall of (year) 08 along with the names of the instructors. (2 pts) 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)