select d.realname 评价单位,c.name 评分项,sum (a.SCORE 分数)
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
group  by d.realname,c.name