查询全部学生都选修的课程的课程号和课程名

select C#,Cname from Course where C# in (select c# from sc group by c#)