回答編集履歴
3
コード修正
test
CHANGED
|
@@ -56,7 +56,7 @@
|
|
|
56
56
|
|
|
57
57
|
Base.PrefecturalID, PrefName.PrefecturalName
|
|
58
58
|
|
|
59
|
-
, Prod
|
|
59
|
+
, ProdName.ProductName, Base.SumP AS 販売合計金額
|
|
60
60
|
|
|
61
61
|
FROM (
|
|
62
62
|
|
|
@@ -76,8 +76,8 @@
|
|
|
76
76
|
|
|
77
77
|
INNER JOIN Prefecturals PrefName ON Base.PrefecturalID = PrefName.PrefecturalID
|
|
78
78
|
|
|
79
|
-
INNER JOIN Products Prod
|
|
79
|
+
INNER JOIN Products ProdName ON Base.ProductID = ProdName.ProductID
|
|
80
80
|
|
|
81
|
-
ORDER BY Base.PrefecturalID, Pr
|
|
81
|
+
ORDER BY Base.PrefecturalID, ProdName.ProductName
|
|
82
82
|
|
|
83
83
|
```
|
2
誤字修正
test
CHANGED
|
@@ -48,7 +48,7 @@
|
|
|
48
48
|
|
|
49
49
|
ところでこのSQLはこのままでも動作するとは思うのですが、相当変かもしれません。
|
|
50
50
|
|
|
51
|
-
Dひょっとしてこれでも同じ結果が得られるのでは？
|
|
51
|
+
DBの中身が分からないのでなんともいえませんが、ひょっとしてこれでも同じ結果が得られるのでは？
|
|
52
52
|
|
|
53
53
|
```sql
|
|
54
54
|
|
1
コード修正
test
CHANGED
|
@@ -54,13 +54,13 @@
|
|
|
54
54
|
|
|
55
55
|
SELECT
|
|
56
56
|
|
|
57
|
-
|
|
57
|
+
Base.PrefecturalID, PrefName.PrefecturalName
|
|
58
58
|
|
|
59
|
-
, ProdfName.ProductName,
|
|
59
|
+
, ProdfName.ProductName, Base.SumP AS 販売合計金額
|
|
60
60
|
|
|
61
61
|
FROM (
|
|
62
62
|
|
|
63
|
-
SELECT Pref.PrefecturalID, Prod.ProductID, SUM(Sale.Quantity * Prod.Price) AS P
|
|
63
|
+
SELECT Pref.PrefecturalID, Prod.ProductID, SUM(Sale.Quantity * Prod.Price) AS SumP
|
|
64
64
|
|
|
65
65
|
FROM Prefecturals Pref
|
|
66
66
|
|
|
@@ -72,12 +72,12 @@
|
|
|
72
72
|
|
|
73
73
|
GROUP BY Pref.PrefecturalID, Prod.ProductID
|
|
74
74
|
|
|
75
|
-
)
|
|
75
|
+
) Base
|
|
76
76
|
|
|
77
|
-
INNER JOIN Prefecturals PrefName ON
|
|
77
|
+
INNER JOIN Prefecturals PrefName ON Base.PrefecturalID = PrefName.PrefecturalID
|
|
78
78
|
|
|
79
|
-
INNER JOIN Products ProdfName ON
|
|
79
|
+
INNER JOIN Products ProdfName ON Base.ProductID = ProdfName.PrefecturalID
|
|
80
80
|
|
|
81
|
-
ORDER BY
|
|
81
|
+
ORDER BY Base.PrefecturalID, PrefName.PrefecturalName
|
|
82
82
|
|
|
83
83
|
```
|