如下:
select n_name,case when b_sore>=60 then '合格' else '不合格' END
from (
select `name` as n_name, min(b) as b_sore from table_x
group by `name`
) as table_y;
新情况:
# 用个偏门招数
select n_name,case when b_sore='不合格' then '不合格' else '合格' END
from (
select `name` as n_name, min(b) as b_sore from table_x
group by `name`
) as table_y;