Question

Create sql queries to find the following

miscrosoft access compatible commands please

9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by the same professor, showing the semester name and the semester name, the course title, and the professor name Snip20200514_28.png Q Search SQL Given the following schema: COURSE(Code. Title, Credits) EXAM(Course. Student, Grade, Score) GRADUATIONPATH(Course, Sudent) SCHEDULE(Professor, Course, Semester. Section) PROFESSOR(ID. Name, SSN) STUDENT(ID, Name, SSN)

Answer 1

9)

SELECT Course, Grade FROM E XAM WHERE Grade = 'A' GROUP BY Course HAVING count(*) >= 3;

10)

SELECT Semester, count(Section) FROM SCHEDULE GROUP BY Semester ORDER BY count(Section) DESC;

NOTE: As per HOMEWORKLIB POLICY I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.