concat(f_name, ' ', l_name) as full_name, concat(f_name, ' ', l_name, ' - ', coalesce(department, 'No Dept')) as full_name_dept ...