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?
SQL: SELECT dept_name, building FROM department WHERE budget > (SELECT AVG(budget) FROM department)