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