What is the name and building of the departments whose budget is more than the average budget?
CREATE TABLE department (dept_name VARCHAR, building VARCHAR, budget INTEGER)
SELECT dept_name, building FROM department WHERE budget > (SELECT AVG(budget) FROM department)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE department (dept_name VARCHAR, building VARCHAR, budget INTEGER) Question: What is the name and building of the departments whose budget is more than the average budget? [/INST] SELECT dept_name, building FROM department WHERE budget > (SELECT AVG(budget) FROM department) </s>