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' OR T2.enroll_grade  =  'A'
Find names of all students who took some course and got A or 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 ' OR T2.enroll_grade = '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 = value or t2 . enroll_grade = value
Find names of all students who took some course and got A or C .