回答編集履歴
1
ちょうせい
test
CHANGED
@@ -1,19 +1,21 @@
|
|
1
1
|
where句までをサブクエリにしてgroup byをあとからやってはだめですか?
|
2
|
+
(クォートを調整)
|
3
|
+
```SQL
|
2
4
|
|
3
|
-
```SQL
|
4
5
|
select 地域,COUNT(*) as 回数
|
5
6
|
from (SELECT
|
6
7
|
CASE
|
7
|
-
WHEN user.BUSYO_CD IN (
|
8
|
+
WHEN user.BUSYO_CD IN ('014', '023') THEN '〇'
|
8
|
-
WHEN user.BUSYO_CD IN (
|
9
|
+
WHEN user.BUSYO_CD IN ('064') THEN '△'
|
9
|
-
WHEN user.BUSYO_CD IN (
|
10
|
+
WHEN user.BUSYO_CD IN ('065') THEN '□'
|
10
|
-
WHEN user.BUSYO_CD IN (
|
11
|
+
WHEN user.BUSYO_CD IN ('066') THEN '×'
|
11
12
|
END as 地域
|
12
13
|
FROM
|
13
14
|
log_table log
|
14
15
|
LEFT JOIN user_table user on log.user_id = user.user_id
|
15
16
|
WHERE
|
16
|
-
log.time BETWEEN
|
17
|
+
log.time BETWEEN '2022/12/26' and '2023/01/25'
|
17
18
|
) as t1
|
18
19
|
GROUP BY 地域
|
20
|
+
|
19
21
|
```
|