MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
Student (school-id, sch-roll-no, sname, saddress)School (school-id, sch-name, sch-address, sch-phone)Enrolment(school-id sch-roll-no, erollno, examname)ExamResult(erollno, examname, marks)What does the following SQL query output?SELECT sch-name, COUNT (*)FROM School C, Enrolment E, ExamResult RWHERE E.school-id = C.school-idANDE.examname = R.examname AND E.erollno = R.erollnoANDR.marks = 100 AND S.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 |
| Answer» E. | |