select C# as 课程号,count() as 人数 from sc group by C# order by count() desc,c#