select sno from T group by sno having sum(case subject when '语文' then score else null end) >= 60 and sum(case subject when '数学' then score else null end) < 60
点赞 1

相关推荐

投递美团等公司10个岗位
点赞 评论 收藏
转发
牛客网
牛客企业服务