Using the schema below:

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 returns the number of students with NULL GPA, grouped by their EntranceYear?

Question

Using the schema below:

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 returns the number of students with NULL GPA, grouped by their EntranceYear?

Answer

SELECT EntranceYear, COUNT(GPA)   
 FROM STUDENT   
 GROUP BY EntranceYear   
 HAVING GPA IS NULL;

Answer

SELECT COUNT(*)   
 FROM STUDENT   
 GROUP BY EntranceYear   
 WHERE GPA IS NULL;

Answer

SELECT EntranceYear, COUNT(*)   
 FROM STUDENT   
 WHERE GPA IS NULL   
 GROUP BY EntranceYear;

Answer

SELECT GPA, COUNT(*)   
 FROM STUDENT   
 WHERE GPA IS NULL   
 GROUP BY EntranceYear;

Answer

SELECT EntranceYear, COUNT(*)   
 FROM STUDENT   
 WHERE GPA = NULL   
 GROUP BY EntranceYear;

Crowdly