show_employees_list.sql

select distinct
       u.id
     , u.last_name
     , u.first_name
     , u.last_name_kana
     , case when d.user_id is null
            then 2
            when d.user_id is not null
            then 1
       end
  from employees as e
  left join users u
    on e.user_id = u.id
  left outer join deliverers as d
    on e.user_id = d.user_id
   and e.employee_id = d.employee_id
 where e.employee_id = 10000001
 order by
       u.last_name_kana asc