| | |
|---|
| | | IFNULL(ROUND(avg(user_score), 2), 0) as averageScore, -- 平均分 |
|---|
| | | IFNULL(ROUND((COUNT(DISTINCT b.create_user) * 100.0 / COUNT(DISTINCT c.user_id)), 2), 0) AS referencePercentage -- 参考百分比 |
|---|
| | | FROM t_exam_paper a |
|---|
| | | LEFT JOIN t_exam_paper_answer b ON a.id = b.exam_paper_id AND (b.invalid = 0 OR b.invalid IS NULL) |
|---|
| | | LEFT JOIN t_exam_paper_user c ON a.id = c.exam_paper_id |
|---|
| | | LEFT JOIN t_exam_paper_answer b ON a.id = b.exam_paper_id AND (b.invalid = 0 OR b.invalid IS NULL) AND c.user_id = b.create_user |
|---|
| | | <if test="deptIds != null and deptIds.size() > 0"> |
|---|
| | | LEFT JOIN t_user_department d ON c.user_id = d.user_id |
|---|
| | | </if> |
|---|
