The Payroll Bill

Finance at Kestrel Labs is reconciling what each team costs against what each team was given, and the first half of that is the salary bill: for every team, the sum of what its people are paid. The reconciliation sheet is read top-down starting with the most expensive team, because that is the end at which any overspend will be.

Salaries are recorded per person and the sheet names teams, so the two facts have to be brought together before anything can be added up.

departments — one row per team. budget is that team's annual budget in dollars.

employees — one row per person. department_id is the team they sit on, given as the matching id in departments; salary is annual pay in dollars; hire_date is the day they started, written year-month-day; manager_id is the id of the person they report to, and is NULL for anyone who reports to nobody.

Both tables already exist in the database — there is nothing to create or load.

Task: Write a query returning two columns, name (the team's name) and total_payroll (the sum of the salaries of everyone on that team), one row per team, most expensive team first. No two teams have the same total here. A team with no employees would not appear in the result at all.

Example output — shape only, on invented teams and totals: