|1. Use the Student database to write queries for the following questions:|
Student (Name, Student_no, Class, Major)
Course ( Course_name, Course_no, Credit_hours, Department)
Section ( SectionID, Course_no, Semester, Year, Instructor)
GradeReport ( Student_no, SectionID, Grade)
a) Retrieve the names of all courses taught by Professor King in 2007 and 2008.
b) 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.
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 names and major departments of all straight-A students (students who have a grade of A in all their courses)
e) Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.