CREATE TABLE employee (EMP_FNAME VARCHAR2, EMP_LNAME VARCHAR2, EMP_NUM VARCHAR2)
CREATE TABLE professor (dept_code VARCHAR2, EMP_NUM VARCHAR2)
CREATE TABLE department (dept_code VARCHAR2)

What is the first and last name of the professor in biology department?
SELECT T3.EMP_FNAME, T3.EMP_LNAME FROM professor AS T1 JOIN department AS T2 ON T1.dept_code = T2.dept_code JOIN employee AS T3 ON T1.EMP_NUM = T3.EMP_NUM WHERE DEPT_NAME = "Biology"
SELECT "T3"."EMP_FNAME", "T3"."EMP_LNAME" FROM "professor" "T1" JOIN "department" "T2" ON "T1"."dept_code" = "T2"."dept_code" JOIN "employee" "T3" ON "T1"."EMP_NUM" = "T3"."EMP_NUM" WHERE "Biology" = "DEPT_NAME"