用SQL语言,查询选修了两门以上课程的学生号和姓名?有三个表,student(sno,name,sex,birthday,class),course(cno,cname,tno）score(sno,cno,degree)

用SQL语言,查询选修了两门以上课程的学生号和姓名?有三个表,student(sno,name,sex,birthday,class),course(cno,cname,tno）score(sno,cno,degree)
用SQL语言,查询选修了两门以上课程的学生号和姓名?
有三个表,student(sno,name,sex,birthday,class),
course(cno,cname,tno）
score(sno,cno,degree)

用SQL语言,查询选修了两门以上课程的学生号和姓名?有三个表,student(sno,name,sex,birthday,class),course(cno,cname,tno）score(sno,cno,degree)
select s.sno,s.name from student s
where s.sno in(select sno from score sc
group by sc.cno having sum(sc.sno)>2