SELECT DISTINCT stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num = T2.stu_num WHERE enroll_grade = 'C'
Apa nama pertama siswa yang mendapat kelas C di kelas mana pun?
CREATE TABLE student (stu_num VARCHAR); CREATE TABLE enroll (stu_num VARCHAR)