For each Computer Sciences class, print the cno, sectno, and the average gpa of

Question

For each Computer Sciences class, print the cno, sectno, and the average gpa of the students enrolled in the class.

I tried...

SELECT cno, sectno, gpa, dname
FROM Enroll, Student
Where dname = 'Computer Sciences' and GPA = (SELECT AVG(gpa) FROM Student)

However it gives me no results. Just the column name.

I would appreciate anyone being able to show me how to find the average gpa of the students enrolled in the Computer Sciences class.

Here are the Tables...

Student(sid,sname,sex,age,year,qpa)
Dept(dname,numphds)
Prof (pname,dname)
Course (cno,cname,dname)
Major(dname,sid)
Section(dname,cno,sectno,pname)
Enroll(sid,grade,dname,cno,sectno)

Explanation / Answer

You will get average of all dnames, including Computer Science SELECT avg(s.gpa), e.dname FROM Enroll e, Student s Where e.sid = s.sid group by e.dname

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---