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