我们现在有个需求,根据不同分数统计对应级别
大于等于90分的是"A"级别
大于等于80小于等于90是"B"级别
大于等于70小于等于60是"C"级别
小于60是"F"级别
SELECT
stu.grade,
(
CASE
WHEN (
isnull( stu.grade )) THEN
'无'
WHEN (
ifnull(( stu.grade ), 0 ) >= ifnull( 90, 9999 )) THEN
'A'
WHEN ((
ifnull(( stu.grade ), 0 ) >= ifnull( 80, 9999 ))
AND (
ifnull(( stu.grade ), 0 ) <= ifnull( 90, 9999 ))) THEN 'B' WHEN (( ifnull((stu.grade), 0 ) >= ifnull(70, 9999 ))
AND (
ifnull((stu.grade), 0 ) <= ifnull(80, 9999 ))) THEN 'C' WHEN (( ifnull((stu.grade), 0 ) >= ifnull(60, 9999 ))
AND (
ifnull((stu.grade), 0 ) <= ifnull(70, 9999 ))) THEN 'D' WHEN (( ifnull(( stu.grade), 0 ) < ifnull(60, 9999 ))) THEN
'F'
END
) AS `poldSttpType`
FROM
stu stu;