| select store_1.store_type as c0, employee_manager_1.management_role as c1 from store as store_1, inventory_fact_1997 as inventory, employee as employee_1, employee as employee_manager_1 where inventory.store_id = store_1.store_id and employee_1.supervisor_id = employee_manager_1.employee_id and inventory.time_id = employee_1.employee_id and (employee_manager_1.management_role in ('Middle Management', 'Store Management')) group by store_1.store_type, employee_manager_1.management_role order by store_1.store_type ASC NULLS LAST, employee_manager_1.management_role ASC NULLS LAST; |