967
2021-02-10 22:06:18
0
SELECT (SUM(eval_how)+SUM(eval_planning)+SUM(eval_goal)+SUM(eval_consider)+SUM(eval_test)) / COUNT(*) / 5 as lectureScore
FROM registers r, subjects s
WHERE r.subject_no = '10003' AND subj_professor='강창구'
AND reg_year=2020 AND reg_semester='1'
평균쿼리를 이렇게 정리하는게 좀더 깔끔해보이네요...