Database: college_2
Question: What are the names and budgets of departments with budgets greater than the average?
SQL:
SELECT dept_name ,  budget FROM department WHERE budget  >  (SELECT avg(budget) FROM department)