CREATE TABLE student (stu_fname VARCHAR, stu_num VARCHAR)
CREATE TABLE CLASS (class_code VARCHAR, crs_code VARCHAR)
CREATE TABLE enroll (class_code VARCHAR, stu_num VARCHAR, enroll_grade VARCHAR)

What is the first name of students enrolled in class ACCT-211 and got grade C?
SELECT T3.stu_fname FROM CLASS AS T1 JOIN enroll AS T2 ON T1.class_code = T2.class_code JOIN student AS T3 ON T2.stu_num = T3.stu_num WHERE T1.crs_code = 'ACCT-211' AND T2.enroll_grade = 'C'
SELECT "T3"."stu_fname" FROM "CLASS" AS "T1" JOIN "enroll" AS "T2" ON "T1"."class_code" = "T2"."class_code" AND "T2"."enroll_grade" = 'C' JOIN "student" AS "T3" ON "T2"."stu_num" = "T3"."stu_num" WHERE "T1"."crs_code" = 'ACCT-211'