Find the number of professors in accounting department.
CREATE TABLE professor (
    dept_code VARCHAR
)

CREATE TABLE department (
    dept_code VARCHAR
)
SELECT COUNT(*) FROM professor AS T1 JOIN department AS T2 ON T1.dept_code = T2.dept_code WHERE DEPT_NAME = "Accounting"
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 number of professors in accounting department. ### Input: CREATE TABLE professor (
    dept_code VARCHAR
)

CREATE TABLE department (
    dept_code VARCHAR
) ### Response: SELECT COUNT(*) FROM professor AS T1 JOIN department AS T2 ON T1.dept_code = T2.dept_code WHERE DEPT_NAME = "Accounting"