Question 1 ( 80 points). Specify the following queries in SQL on the database schema of Figure 1.
Specify the following queries in SQL on the database schema of Figure 1.
(a) Retrieve the Major of student "Jamie Garcia" who is a senior.
(b) Retrieve the names of all courses taught by professor Patel in 10 and 11.
(c) For each section taught by professor Patel, retrieve the course number, semester, year, and number of students who took the section.
(d) Retrieve the name and transcript of each senior student majoring in BUSN. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.
(e) Retrieve the names of all students who do not have a major.
(f) Return the names of all students grouped together by major.
(g) List all courses offered by the university. Group them together by Department.
(h) Generate a report on each major, returning the total number of students per.major.
1.Specify the following queries in SQL on the database schema of Figure 1. (a) Retrieve the Major of student "Jamie Garcia"who is a senior. (b) Retrieve the names of all courses taught by professor Patel in 10 and 11. year, and number of students who took the section. (c) For each section taught by professor Patel,retrieve the course number, semester, (d) Retrieve the name and transcript of each senior student majoring in and grade for each course completed by the student. BUSN.Transcript includes course name,course number,credit hours,semester,year, (e) Retrieve the names of all students who do not have a major. (f) Return the names of all students grouped together by major. (g) List all courses offered by the university. Group them together by Department. (h) Generate a report on each major,returning the total number of students per.major