select
empleado."name",
sucursal.nombre as sucursal,
empleado.birthday as "fecha_nacimiento",
contrato.date_start as "inicio",
to_char(empleado.birthday, 'dd-mm') as cumple


FROM hr_employee as empleado
LEFT JOIN hr_contract as contrato on contrato.employee_id = empleado."id"
left join res_sucursal as sucursal on sucursal.id=empleado.sucursal_id
where contrato.date_end IS NULL
and contrato.subcompania_id=1

ORDER BY to_char(empleado.birthday, 'mm dd') ASC