COUNT(*)に対するCASE
下記の表から部署ごとの人数を計算し、2人以上か未満かも表示する
社員ID | 部署 | 性別 | 年齢 |
1 | Creater | male | 32 |
2 | Creater | male | 30 |
3 | Creater | female | 23 |
4 | Valuer | male | 45 |
5 | Valuer | male | 50 |
6 | Apointer | female | 40 |
7 | Apointer | female | 42 |
8 | Apointer | male | 52 |
9 | Apointer | male | 34 |
10 | Apointer | female | 41 |
11 | Getter | male | 29 |
12 | Getter | female | 36 |
SELECT
dept,CASE WHEN COUNT(*) > 2 THEN '> 2'
ELSE '< 2'
END AS '2人以上?'
FROM test
GROUP BY dept
■実行結果
dept | 2人以上? |
Apointer | > 2 |
Creater | > 2 |
Getter | < 2 |
Valuer | < 2 |