Specify the following queries in SQL on the University database 1. Retrieve the names of all courses taught by professor

[answerhappygod]

Specify the following queries in SQL on the University
database
1. Retrieve the names of all courses taught by professor King in
Fall 21.
2. Retrieve the name and transcript of each senior student
(Class=4) majoring in
CS. Transcript includes course name, course number, credit hours,
semester,
year, and grade for each course completed by the student.
3. Retrieve the names and major departments of all straight A
students (students
who have a grade of A in all their courses).
4. Retrieve department names and the number of students with that
department
major (sorted in decreasing order of the number of students)