回答編集履歴
1
コード修正
answer
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
F1でグループ化してF2で集計
|
18
18
|
```sql
|
19
|
-
select
|
19
|
+
select F1, Sum(F2) As F2_Sum
|
20
20
|
from table1
|
21
21
|
group by F1;
|
22
22
|
```
|
@@ -56,7 +56,7 @@
|
|
56
56
|
|
57
57
|
```sql
|
58
58
|
select F1, F2
|
59
|
-
from table2 inner join table3 on table2 .FKey =
|
59
|
+
from table2 inner join table3 on table2 .FKey = table3.FKey;
|
60
60
|
```
|
61
61
|
|
62
62
|
| F1 |F2 |
|