select 
d.realname 评价单位,c.name as 评分项,sum(a.score) as 分数
from  EVAL_SCORE a
left join EVAL_EVALUATOR b on a.EVALUATOR_ID=b.id
left join EVAL_EVALUATE_TARGET c on a.field_id=c.id
left join t_s_base_user d on b.user_id=d.id
where c.name not like 'null'
and d.realname not like 'null'
group  by d.realname,c.name