SELECT dept_name ,  building FROM department WHERE budget  >  (SELECT avg(budget) FROM department)
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 )
select dept_name , building from department where budget > ( select avg ( budget ) from department )
What is the name and building of the departments whose budget is more than the average budget ?