blob: f72e7b6522d575147e76b0883e44a91fb4290b45 [file] [log] [blame]
select employee.employee_id as c0, employee.full_name as c1 from employee as employee where employee.supervisor_id = 1071 group by employee.employee_id, employee.full_name order by employee.employee_id ASC NULLS LAST;