真题

分类: 文章 • 2022-10-20 00:29:32

牛客网，网易校招

select Sname
from S
where SNo not in
(select SNO
from SC
where cno not in
(select cno
from C
where
CTEACHER==‘小易’))

select sname,ave(sum(score))
from S
join SC
on S.SNO=SC.SNO
where
(select score
from S
where score>90
ground by sno
having count(cno)>3）