select sei.office_name, nvl(ROUND(AVG(sei.COMP_CHECK), 2), 0) avg_score
from SECURITY_EMPLOYEE_INFO sei
WHERE sei.office_name in ('运输处', '货运处', '客运处', '机务处', '工务处', '电务处', '车辆处', '供电处')
and (SEI.ON_GUARD IS NULL OR SEI.ON_GUARD = 0)
group by sei.office_name
--order by avg_score desc
order by instr('运输处, 货运处, 客运处, 机务处, 工务处, 电务处, 车辆处, 供电处', sei.office_name);