| select store.store_country as c0, employee.management_role as c1, employee.position_title as c2, sum(salary.salary_paid) as m0 from store as store, employee as employee, salary as salary where salary.employee_id = employee.employee_id and employee.store_id = store.store_id and employee.management_role = 'Store Management' and employee.position_title in ('Store Assistant Manager', 'Store Manager', 'Store Shift Supervisor') group by store.store_country, employee.management_role, employee.position_title; |