Find the last name and hire date of the professor who is in office DRE 102.
CREATE TABLE employee (
    emp_lname VARCHAR,
    emp_hiredate VARCHAR,
    emp_num VARCHAR
)

CREATE TABLE professor (
    emp_num VARCHAR,
    prof_office VARCHAR
)
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'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the last name and hire date of the professor who is in office DRE 102. ### Input: CREATE TABLE employee (
    emp_lname VARCHAR,
    emp_hiredate VARCHAR,
    emp_num VARCHAR
)

CREATE TABLE professor (
    emp_num VARCHAR,
    prof_office VARCHAR
) ### Response: 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'