Find the name and budget of departments whose budgets are more than the average budget.
CREATE TABLE department (dept_name VARCHAR, budget INTEGER)
SELECT dept_name, budget 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, budget INTEGER) Question: Find the name and budget of departments whose budgets are more than the average budget. [/INST] SELECT dept_name, budget FROM department WHERE budget > (SELECT AVG(budget) FROM department) </s>