last name and hire date please.
select t1.emp_lname, t1.emp_hiredate from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num where t2.prof_office = 'DRE 102'
Thanks. What are those professors' degree?
select t1.emp_lname, t2.prof_high_degree from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num where t2.prof_office = 'DRE 102'