Given the following database sample instance, write the following SQL queries: (CLO 3)

Student

Name	Student_number	Class	Major
Smith	17	1	CS
Brown	8	2	CS

Course

Course_name	Course_number	Credit_hours	Department
Intro to computers	CS1310	4	CS
Data Structure	CS3320	4	CS
Discrete Math	MATH2410	3	MATH
Database	CS3380	3	CS

Section

Section_number	Course_number	Semester	Year	Instructor
85	MATH2410	FALL	07	KING
92	CS1310	FALL	07	Anderson
102	CS3320	SPRING	08	Knuth
112	MATH2410	FALL	08	Chang
119	CS1310	FALL	08	Anderson
135	CS3380	FALL	08	Stone

Grade_Report

Student_number	Section_identifier	Course_number	Grade
17	112	MATH2410	B
17	119	CS1310	C
8	85	MATH2410	A
8	92	CS1310	A
8	102	CS3320	B
8	135	CS3380	A

Prerequisite

Course_number	Prerequisite
CS3380	CS3320
CS3380	MATH2410
CS3320	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)