SELECT Cname,COUNT(1) FROM Course INNER JOIN SC ON C.Cno = SC.Cno GROUP BY Cname
select Cname as [Name],COUNT(1) as [Count] from dbo.Course c2 join dbo.SC sc on sc.Cno=c2.Cno Group by Cname谢谢!
select c.Cname as [Name],( case when sc.Cno is null then '0' else Count(sc.Score) end) as [Count] from dbo.SC sc right join dbo.Course c on sc.Cno=c.Cno group by c.Cname,sc.Cno
SELECT Cname,COUNT(1)
FROM Course INNER JOIN SC ON C.Cno = SC.Cno
GROUP BY Cname
select Cname as [Name],COUNT(1) as [Count] from dbo.Course c2
join dbo.SC sc
on sc.Cno=c2.Cno
Group by Cname谢谢!
else
Count(sc.Score)
end) as [Count] from dbo.SC sc
right join dbo.Course c
on sc.Cno=c.Cno
group by c.Cname,sc.Cno