Using the schema:
● STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)
● DEPT(Did, Dname)
● PROF(Pid, Pname, Did, Birth_Date)
● COURSE(Cno, Did, Cname)
● SECTION(Sectno, Did, Cno, Pid)
● ENROLL(Eid, Sid, Cno, Sectno, Grade)
Which SQL query correctly finds the maximum grade of students who have enrolled in the course with ID 7?

Question

Using the schema: 
 ● STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA) 
 ● DEPT(Did, Dname) 
 ● PROF(Pid, Pname, Did, Birth_Date) 
 ● COURSE(Cno, Did, Cname) 
 ● SECTION(Sectno, Did, Cno, Pid) 
 ● ENROLL(Eid, Sid, Cno, Sectno, Grade) 
 Which SQL query correctly finds the maximum grade of students who have enrolled in the course with ID 7?

Answer

SELECT MAX(Grade)   
 FROM COURSE   
 WHERE Cno = 7;

Answer

SELECT MAX(Grade)   
 FROM STUDENT   
 WHERE Cno = 7;

Answer

SELECT MAX(Grade)   
 FROM ENROLL   
 WHERE Cno = 7;

Answer

SELECT MAX(Grade)   
 FROM ENROLL   
 WHERE Sectno = 7;

Answer

SELECT MAX(Grade)   
 FROM ENROLL   
 WHERE Sid = 7;

Crowdly

Using the schema: ● STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA) ● DE...

Want instant access to all verified answers on moodle.sdu.edu.kz?