SELECT
lecturer,
college,
MAX(phone_number) AS phone,
ROUND(SUM(score), 2) AS total_score,
ROUND(AVG(score), 2) AS average_score,
COUNT(lecturer) AS count
FROM lecturer_assessment
WHERE submition_period = '202308-2'
GROUP BY lecturer, college;
【SQL】去重查询平均值和信息
于 2023-11-07 15:59:09 首次发布