Consider the following relational schema:
- $\text{Student} (\underline{\text{school-id}, \text{sch-roll-no}}, \text{sname}, \text{saddress})$
- $\text{School} (\underline{\text{school-id}}, \text{sch-name}, \text{sch-address}, \text{sch-phone})$
- $\text{Enrolment}(\underline{\text{school-id}, \text{sch-roll-no}}, \text{erollno}, \text{examname})$
- $\text{ExamResult}(\underline{\text{erollno}, \text{examname}}, \text{marks})$
What does the following SQL query output?
SELECT sch-name, COUNT (*)
FROM School C, Enrolment E, ExamResult R
WHERE E.school-id = C.school-id
AND
E.examname = R.examname AND E.erollno = R.erollno
AND
R.marks = 100 AND E.school-id IN (SELECT school-id
FROM student
GROUP BY school-id
HAVING COUNT (*) > 200)
GROUP By school-id
-
for each school with more than $200$ students appearing in exams, the name of the school and the number of $100s$ scored by its students
-
for each school with more than $200$ students in it, the name of the school and the number of $100s$ scored by its students
-
for each school with more than $200$ students in it, the name of the school and the number of its students scoring $100$ in at least one exam
-
nothing; the query has a syntax error