用SQL查询某专业选修了两门以及两门以上课程的学生的学号
select s.sno,s.name from student s where s.sno in(select sno from score sc group by sc.cno having count(sc.sno)>1