背景
有点忘了，记录下
写法一
case colume
when condition then result
when condition then result
when condition then result
else result
end
写法二
case
when condition then result
when condition then result
when condition then result
else result
end