What is the name and building of the departments whose budget is more than the average budget?
SELECT dept_name ,  building FROM department WHERE budget  >  (SELECT avg(budget) FROM department)
departments whose budget is more than the average budget refers to budget > (SELECT AVG(budget) FROM department); name and building of the departments refers to dept_name, building;