查询每一门课程成绩都大于等于90分的学生学号、姓名和性别把值送往另一个已经存在的基本表STUSNOSNAMESSEX中。

INSERT INTO STU(SNO,SNAME,SSEX) SELECT SC.SNO, SNAME, SSEX FROM SC,STU WHERE SC.SNO=STU.SNO AND CNO IN (SELECT CNO FROM SC WHERE SCORE>=90 GROUP BY CNO HAVING COUNT()= (SELECT COUNT() FROM STU)));