Thank you. What are the office extensions numbers of professor Donelly and Blalock please?
select t3.dept_extension from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num join department as t3 on t2.dept_code = t3.dept_code where emp_lname = "Donelly" or emp_lname = "Blalock"
Thank you! Can you please confirm the school code of the History Department?
select t3.school_code from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num join department as t3 on t2.dept_code = t3.dept_code where t3.dept_name = 'History'