CREATE TABLE enroll (stu_num VARCHAR(255), class_code VARCHAR(255)); CREATE TABLE CLASS (class_code VARCHAR(255), crs_code VARCHAR(255)); CREATE TABLE student (stu_fname VARCHAR(255), stu_num VARCHAR(255), stu_lname VARCHAR(255))
What is the first name of the student whose last name starting with the letter S and is taking ACCT-211 class?
    
SQL: SELECT T1.stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num = T2.stu_num JOIN CLASS AS T3 ON T2.class_code = T3.class_code WHERE T3.crs_code = 'ACCT-211' AND T1.stu_lname LIKE 'S%'