1. Specify the following queries in SQL on the database schema of figure1.

Retrieve the name of all senior students majoring in COSC (Computer Science).

Retrieve the names of all courses taught by professor King in 1985 and 1986.

For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section.

Retrieve the name and transcript of each senior student (Class=5) majoring in COSC. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.

Retrieve the names and major departments of all A students (students who have a grade of A in all their courses).

Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.

Table: STUDENT

Name | StudentNumber | Class | Major

Table: COURSE

CourseName | CourseNumber | CreditHours | Department | Professor

Table: PREREQUISITE

CourseNumber | PrerequisiteNumber

Table: SECTION

SectionIdentifier | CourseNumber | Semester | Year | Instructor

Table: GRADE_REPORT

StudentNumber | SectionNumber | Grade