select distinct SNO from T where SNO in (select SNO from T where subject='语文' and score>=60) and SNO in (select SNO from T where subject='数学' and score<60)
点赞 评论

相关推荐

牛客网
牛客企业服务