->where('fa_id',$faId)
->field('COALESCE(FORMAT(AVG(score),1),0) as all_score,
COALESCE(FORMAT(AVG(score_major),1),0) as major_score,
COALESCE(FORMAT(AVG(score_attitude),1),0) as attitude_score,
COALESCE(FORMAT(AVG(score_experience),1),0) as experience_score')查看语句就变成了SELECT COALESCE(FORMAT(AVG(score),1),0) as all_score,
COALESCE(FORMAT(AVG(score_major),0) as major_score,
COALESCE(FORMAT(AVG(score_attitude),0) as attitude_score,
COALESCE(FORMAT(AVG(score_experience),0) as experience_score 最佳答案
