CREATE TABLE enroll (stu_num VARCHAR(255), enroll_grade VARCHAR(255)); CREATE TABLE student (stu_fname VARCHAR(255), stu_lname VARCHAR(255), stu_num VARCHAR(255))
Find names of all students who took some course and got A or C.
    
SQL: 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'