| select store.store_country as c0, employee.management_role as c1, employee.position_title as c2, employee.position_id as c3 from employee as employee, store as store, salary as salary where employee.store_id = store.store_id and salary.employee_id = employee.employee_id and (employee.management_role = 'Store Management') group by store.store_country, employee.management_role, employee.position_title, employee.position_id order by store.store_country ASC NULLS LAST, employee.management_role ASC NULLS LAST, employee.position_id ASC NULLS LAST; |