原网址:https://www.cnblogs.com/zybcn/p/8931297.html
https://www.cnblogs.com/Richardzhu/p/3571670.html
CASE WHEN s.s_sex = '1' THEN '男' WHEN s.s_sex = '2' THEN '女' ELSE '其他' END as sex
CASE s.s_sex WHEN '1' THEN '男' WHEN '2' THEN '女' ELSE '其他' END as sex