user
Calculate each department’s budget-to-salary ratio
Given two tables: instructor, department.


assistant
SELECT d.name, (d.budget/ SUM(i.salary)) as budget_salary_ratio FROM instructor i JOIN department d ON i.dept_name = d.name GROUP BY i.dept_name;