题目:90分以上为优秀,80-89为良好,70-79为中等,60-69为合格,否则为不及格。
select s_no,c_no,
case
when report>=90 then'优秀'
when report>=80 then'良好'
when report>=70 then'中等'
when report>=60 then'合格'
else '不及格'
end as 等级
from score;