Can you please show me the current courses being taught with the last name of the instructor teaching them?
SELECT T2.emp_lname ,  T3.crs_description FROM CLASS AS T1 JOIN employee AS T2 ON T1.prof_num   =   T2.emp_num JOIN course AS T3 ON T1.crs_code   =   T3.crs_code
current courses being taught refers to crs_description from course table; last name of the instructor teaching them refers to emp_lname from employee table; need to join CLASS table with employee and course tables on prof_num = emp_num and crs_code = crs_code respectively;