Given the following database sample instance, write the following SQL queries: (CL0 3) Student Name Smith Student number Class 1 8 2 Major CS Brown cs Department Course Course_name Course number Credit hours, Intro to S1310 4 computers Data Structure CS3320 4 Discrete Math MATH2410 3 Database CS3880 3 OS MATH Year Section Section number Course number 85 MATH2410 92 CS1310 102 OS3320 112 MATH 2410 CS1310 125 CSBB 80 Semester FALL FALL SPRING FALL FALL FALL 07 08 os OS 08 Instructor KING Anderson Knuth Chang Anderson Stone Instructor KING 85 Section Section number Course number | Semester MATH2410 FALL CS1310 FALL CS3320 SPRING MATH2410 FALL CS1310 FALL 135 C83380 FALL 08 Anderson Knuth Chang Anderson 08 08 Stone Grade Report Student number Section identifier Grade Course number MATH2410 CS1310 MATH2410 CS1310 0823 20 C83380 85 92 102 135 A B 8 Prerequisite Course number CS3380 C933 80 CS3320 Prerequisite CS3320 MATH2410 O81310 3 LOS 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)