What are the names and budgets of departments with budgets greater than the average?
SELECT dept_name ,  budget FROM department WHERE budget  >  (SELECT avg(budget) FROM department)
names and budgets = SELECT dept_name, budget; departments with budgets greater than the average = WHERE budget > (SELECT AVG(budget) FROM department);