What is the average GPA of all students?
select avg ( t2.stu_gpa ) from enroll as t1 join student as t2 on t1.stu_num = t2.stu_num join class as t3 on t1.class_code = t3.class_code
What is the average GPA of all students enrolled in the course that has the code ACCT-211?
select avg ( t2.stu_gpa ) from enroll as t1 join student as t2 on t1.stu_num = t2.stu_num join class as t3 on t1.class_code = t3.class_code where t3.crs_code = 'ACCT-211'
What are the grades of all the students in that course?
select t1.enroll_grade from enroll as t1 join student as t2 on t1.stu_num = t2.stu_num join class as t3 on t1.class_code = t3.class_code where t3.crs_code = 'ACCT-211'