What information is on students whose name starts with 'S'?
select * from student where stu_lname like 'S%'
Which of them took course ACCT-211?
select * 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%'
What are their first names?
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%'