Find the first names of all professors?
select emp_fname from professor as t1 join employee as t2 on t1.emp_num = t2.emp_num
Which of those teach more than one class?
select t2.emp_fname from class as t1 join employee as t2 on t1.prof_num = t2.emp_num group by t1.prof_num having count(*) > 1