回答編集履歴
1
調整
test
CHANGED
@@ -8,8 +8,8 @@
|
|
8
8
|
|
9
9
|
having sum(case 項目B when '赤' then 1 else 0 end)>0
|
10
10
|
|
11
|
-
and sum(case 項目B when '青' then 1 else 0 end)=0
|
11
|
+
and sum(case 項目B when '青' then 1 when '黄' then 1 else 0 end)=0
|
12
|
-
|
13
|
-
and sum(case 項目B when '黄' then 1 else 0 end)=0
|
14
12
|
|
15
13
|
```
|
14
|
+
|
15
|
+
※ちょっと効率化
|