select Sno,Sname,Ssex from Student a(nolock) where a.Sno not in (select y.Sno from (select * from Student where Sdept>=80) x right join SC y on x.Sno=y.Sno where x.Sno is null)
Insert into S（SNO,SNAME,SEX）
Select Sno,sname,ssex
From student t1
Where not exists(select *
From sc t2
Where t1.sno=t2.sno and grade>=80)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024