表为FRDemo中的STSCORE表
条件：
结果：
select name , case when English > 80 then 'A' when English >= 70 AND English <= 79 then 'B' when English >= 60 AND English <= 69 then 'C' else 'D' end as English from STSCORE
1min目标场景问卷
立即参与
