| select employee.management_role as c0, employee.position_title as c1, employee.position_id as c2 from employee as employee, salary as salary, time_by_day as time_by_day where salary.employee_id = employee.employee_id and salary.pay_date = time_by_day.the_date and time_by_day.the_year = 1997 group by employee.management_role, employee.position_title, employee.position_id having (count(salary.employee_id) >= 66) order by employee.management_role ASC NULLS LAST, employee.position_id ASC NULLS LAST; |