Database: college_1
Question: What are the first names of all teachers who have taught a course and the corresponding course codes?
SQL:
SELECT T2.emp_fname ,  T1.crs_code FROM CLASS AS T1 JOIN employee AS T2 ON T1.prof_num  =  T2.emp_num