实验四

select count(sno)'总人数'
from student
select count(sno)'选修了课程人数'
from sc
group by sno

select count(distinct sno)'选修了课程人数'
from sc

select cno'课号',count(sno)'人数'
from sc
group by cno