Find the professors whose office is located in room DRE 102?
select * from professor where prof_office = 'DRE 102'
What are their last names?
select t1.emp_lname from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num where t2.prof_office = 'DRE 102'
When were they hired?
select t1.emp_hiredate from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num where t2.prof_office = 'DRE 102'