- 07/13/2019 at 9:49 pm #1440541EduGorillaKeymasterSelect Question Language :
Consider the following relations:
Student (snum: integer, sname: string, major: string, level: string, age: integer)
Class (name: string, meets at: string, room: string, ﬁd: integer)
Enrolled (snum: integer, cname: string)
Faculty (ﬁd: integer, fname: string, deptid: integer)
Consider the following SQL statements:
SELECT DISTINCT S.sname
FROM Student S
WHERE S.snum IN
FROM Enrolled E
GROUP BY E.snum
HAVING COUNT (*) >= ALL (SELECT COUNT (*)
FROM Enrolled E2
GROUP BY E2.snum))
What is the output of the following Query?
Post your Training /Course EnquiryAre You looking institutes / coaching center for
- Name of all the students who are enrolled in every course.
- Name of all the students who are enrolled in some course.
- Name of all the students who are enrolled in maximum no of course.
- None of these.
- IIT-JEE, NEET, CAT
- Bank PO, SSC, Railways
- Study Abroad