MySQL / case when then else end

1、case when 字段，可对字段进行取值范围设置；

SELECT *,
 CASE
  WHEN empage BETWEEN 0 and 30 THEN ‘青年’
  WHEN empage BETWEEN 30 and 40 THEN ‘中年’
  ELSE ‘非人类’
 END AS ‘描述’
FROM emp;

2、case when 字段1，字段2，可对多个字段进行取值映射；

SELECT *,
 CASE
  WHEN empage BETWEEN 20 and 30 THEN ‘青年’
  WHEN empname =‘14:55:15’ THEN ‘帅气’
 END AS ‘描述’
FROM emp;

3、case 字段 when， 字段的具体值；

SELECT *,
 CASE
  WHEN empsex = 0 then ‘女’
  WHEN empsex = 1 then ‘男’
 END as ‘性别’
FROM emp;

eg: 求以下每种员工的数量

#empage > 30 and empsalary <10000000
#empage < 30 and empsalary <10000000
#empage > 30 and empsalary >10000000
#empage < 30 and empsalary >10000000

SELECT
SUM(case<