blob: 20f94757170221ee36a92ff96863e36c6bee3ddf [file] [log] [blame]
select employee_closure.supervisor_id as c0, sum(salary.salary_paid) as m0 from employee_closure as employee_closure, salary as salary where salary.employee_id = employee_closure.employee_id and employee_closure.supervisor_id in (37, 38, 39, 40, 41, 42) group by employee_closure.supervisor_id;