select name,
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
from XS
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
from XS

被折叠的 条评论
为什么被折叠?