回答編集履歴

2

修正結果が未反映だったので、再登録

2019/02/25 23:26

投稿

mackerel6.023
mackerel6.023

スコア317

test CHANGED
File without changes

1

誤字の修正

2019/02/25 23:26

投稿

mackerel6.023
mackerel6.023

スコア317

test CHANGED
@@ -20,7 +20,7 @@
20
20
 
21
21
  SELECT AID FROM
22
22
 
23
- ( SELECT B.AID, SUM(B.BID) AS count FROM B WHERE B.STATUS != '完了' GROUP BY AID )
23
+ ( SELECT B.AID, COUNT(B.BID) AS count FROM B WHERE B.STATUS != '完了' GROUP BY AID )
24
24
 
25
25
  WHERE count = 0
26
26