左右表联合查询

#使用那一列分组就只有那一列有效，其余无效
select studentId '学生id',userName'学生姓名'，
sum(score)'学生总分'，
count(score)'考试科目数量',
avg(score)'各科目平均分'
from result inner join student on result.student=student.id
GROUP BY studentId,userName
having avg(score)>60
order by avg(score) desc;

#主表的全部信息必须显示完毕
select*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;