MYSQL-多表联结查询之左右联结

right join，left join

SELECT studentId '学号',userName '学生名称',
sum (score) '学生各科目总分',
count (score) '考试科目数量',
AVG (score) '各科目平均分',
from result inner join student on result.studentId=student.id
SELECT * from result LEFT JOIN student on result.studentId=student.id
SELECT * from result RIGHT JOIN  student on result.studentId=student.id
GROUP BY studentId,userName
HAVING avg (score)>60
ORDER BY AVG(score) desc