SELECT dept_name ,  budget FROM department WHERE budget  >  (SELECT avg(budget) FROM department)
Find the name and budget of departments whose budgets are more than the average budget.
SELECT dept_name , budget FROM department WHERE budget > ( SELECT avg ( budget ) FROM department )
select dept_name , budget from department where budget > ( select avg ( budget ) from department )
Find the name and budget of departments whose budgets are more than the average budget .