framework/resources/Advanced/mondrian/query5522.q

select employee.position_title as c0, employee.position_id as c1 from employee as employee where (employee.management_role = 'Middle Management') group by employee.position_title, employee.position_id order by employee.position_id ASC NULLS LAST;