这个示例代码她只是计算了表3的平均成绩,而不是真正的GPA : SELECT * FROM (选择AVG(g.Grade)作为average_grade,g.SSN从G年级组按g.SSN)选择a.ssn =s.ssn的内连接学生;Need some help stuck on this problem?
我有学生和课程表:Course(Course_no(primary), Course_name)课程表和计数栏一起。SELECT * FROM Course WHERE(SELECT COUNT(*) FROM Student GROUP BY Course_no WHERE COUNT(*) > 2); +---