摘要:
写SQL,学生表student(studentid,name)绩表score(scoreid,studentid,score)求出平均成绩大于60 且 至少有两门成绩高于70分的学生的编号和姓名/*学生表student(studentid,name)绩表score(scoreid,studentid,score)求出平均成绩大于60 且 至少有两门成绩高于70分的学生的编号和姓名*/select studentid, name from student where studentid in(select studentidfrom scorewhere studentid in (select 阅读全文