CASE WHEN score IS NULL THEN '缺席考试' ELSE '正常' END case when then when then else使用结束后不要忘记加上end,否则sql会报错