What is the average number of honorary professors in the economics department with 1 lecturer?
CREATE TABLE table_name_9 (honorary_professors INTEGER, lecturers VARCHAR, department VARCHAR)
SELECT AVG(honorary_professors) FROM table_name_9 WHERE lecturers = 1 AND department = "economics"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (honorary_professors INTEGER, lecturers VARCHAR, department VARCHAR) Question: What is the average number of honorary professors in the economics department with 1 lecturer? [/INST] SELECT AVG(honorary_professors) FROM table_name_9 WHERE lecturers = 1 AND department = "economics" </s>