select course.cno,cname,count(sno) total
from course left join score on course.cno=score.cno
where attribute='必修'
group by course.cno,cname
拓展:
1、等值连接、外连接:
select *
from course,sc
where course.cno=sc.cno
select*
from course left join sc on course.cno=sc.cno
运行截图:
2、count()
select course.cno,cname,count(sno) total
from course left join sc on course.cno=sc.cno
group by course.cno ,course.cname
select course.cno,cname,count(course.cno) total
from course left join sc on course.cno=sc.cno
group by course.cno ,course.cname
3、group by x
x属性相同的分为一组
group by x,y
x,y属性相同的分为一组