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.