| select employee.management_role as c0, employee.position_title as c1, employee.position_title as c2, employee.position_id as c3 from employee as employee, salary as salary where salary.employee_id = employee.employee_id and (employee.management_role in ('Middle Management', 'Senior Management', 'Store Full Time Staf', 'Store Management', 'Store Temp Staff')) group by employee.management_role, employee.position_title, employee.position_id order by employee.management_role ASC NULLS LAST, employee.position_id ASC NULLS LAST; |