Order the departments by decreasing budget.
select dept_name from department order by budget desc
How many instructors are in the department with the highest budget?
select count(*) from instructor as t1 join department as t2 on t1.dept_name = t2.dept_name order by t2.budget desc limit 1
Also, what is the average salary of those instructors?
select avg(t1.salary), count(*) from instructor as t1 join department as t2 on t1.dept_name = t2.dept_name order by t2.budget desc limit 1