Question

Please answer questions 4 to 7

SQL Given the tollowing whema COURSE ode. Thle, Credits) EXAMCAurse. Stadent. Grade, Score GRADUATIONPALHOure, Suedent) SCHEDULE(Professor, Course, Semester Section PROFESSORİD, Name, SSN) STUDENTOİD, Name, SSN) Formulate SQL queries to find he bove 4. People that are students but are not professors, showing the people name and SSN 5. The courses for which classes have been scheduled but the professor is yet to be defined showing the course title, the semester, and the section The number of sections scheduled in each semester, showing the semester name and the number of sections 6. Courses for which at least three students eamed a grade of A, showing the grade and the coure code 7. (more next page)

please type the answers

Answer 1

If you have any doubts, please give me comment...

-- 4

SELECT Name, SSN

FROM STUDENT;

-- 5

SELECT Title, Semester, Section

FROM COURSE, SCHEDULE

WHERE Code = Course;

-- 6

SELECT Semester, COUNT(*) no_of_sections

FROM SCHEDULE

GROUP BY Semester;

-- 7

SELECT grade, Code

FROM COURSE, EXAM

WHERE Code = Course AND grade = 'A'

GROUP BY Code

HAVING COUNT(*)>3;