1select sno from sc where cno='1' 2select sname from s where sno in (select sno from sc where cno='2') 3select sname from s where dept='计算机系' and datediff(year,birth,getdate())<19
