Could you please find all the names of the students who took some course and got an A?
select t1.stu_fname, t1.stu_lname from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num where t2.enroll_grade = 'A'
Could you please find all the names of the students who took some course and got a C?
select t1.stu_fname, t1.stu_lname from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num where t2.enroll_grade = 'C'
What are their student numbers?
select t1.stu_num from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num where t2.enroll_grade = 'C'
What are the class codes for the students who took some course and got a C?
select t2.class_code from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num where t2.enroll_grade = 'C'
What are the student class and gpa of each of those students?
select stu_class, stu_gpa from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num where t2.enroll_grade = 'C'