select * from ( with tt as (select * from score unpivot (cj for kc in ("语文","数学","英语"))) select kc,(case when cj>=80 then '优秀' when cj>=60 then '及格' else '不及格' end) cj from tt) pivot (max(cj) for kc in ('语文' 语文,'数学' 数学,'英语' 英语))
17,377
社区成员
95,128
社区内容
加载中
试试用AI创作助手写篇文章吧