What is the average department budget?
select avg(budget) from department
Which departments have a budget higher than average?
select * from department where budget > (select avg(budget) from department)
What are their names and buildings?
select dept_name, building from department where budget > (select avg(budget) from department)