select DISTINCT name from table where name in( select DISTINCT name from table GROUP BY name HAVING max(score)<60 )
2 1

相关推荐

牛客网
牛客企业服务