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

相关推荐

牛客网
牛客企业服务