CREATE TABLE professor (emp_num VARCHAR(255), prof_office VARCHAR(255)); CREATE TABLE employee (emp_lname VARCHAR(255), emp_hiredate VARCHAR(255), emp_num VARCHAR(255))
Find the last name and hire date of the professor who is in office DRE 102.
    
SQL: 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'