回答編集履歴
2
修正結果が未反映だったので、再登録
answer
CHANGED
|
File without changes
|
1
誤字の修正
answer
CHANGED
|
@@ -9,7 +9,7 @@
|
|
|
9
9
|
WHERE A.AID =
|
|
10
10
|
(
|
|
11
11
|
SELECT AID FROM
|
|
12
|
-
( SELECT B.AID,
|
|
12
|
+
( SELECT B.AID, COUNT(B.BID) AS count FROM B WHERE B.STATUS != '完了' GROUP BY AID )
|
|
13
13
|
WHERE count = 0
|
|
14
14
|
)
|
|
15
15
|
```
|