GATEverse — GATE CSE previous year questions

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

(A)

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

(B)

for each school with more than $200$ students in it, the name of the school and the number of $100s$ scored by its students

(C)

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

(D)

nothing; the query has a syntax error