What information is there on students who are taking a class?
select * from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num
What are their first and last names?
select t1.stu_fname, t1.stu_lname from student as t1 join enroll as t2 on t1.stu_num = t2.stu_num
Also, what are the descriptions for the courses they are taking?
select t1.stu_fname, t1.stu_lname, t4.crs_description 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 join course as t4 on t3.crs_code = t4.crs_code