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'
What is the last name of the professor whose office is located in DRE 102, and when were they hired?
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 '
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 = value
What is the last name of the professor whose office is located in DRE 102 , and when were they hired ?