Computer Science · Database Management System

Given the relational schemas: STUDENT (Rollno, Name, courseno) COURSE (courseno, coursename, capacity) where Rollno is the primary key of STUDENT, courseno is the primary key of COURSE, and coursename takes unique values. Which of the following queries find the total number of students enrolled in each course along with its coursename? Query A: SELECT coursename, count() 'total' from STUDENT natural join COURSE group by coursename; Query B: SELECT C.coursename, count() 'total' from STUDENT S, COURSE C where S.courseno = C.courseno group by coursename; Query C: SELECT coursename, count() 'total' from COURSE C where courseno in (SELECT courseno from STUDENT);