回答編集履歴
1
商品1種類しか加味されてなかったので修正
answer
CHANGED
|
@@ -16,6 +16,8 @@
|
|
|
16
16
|
max(price) max_price
|
|
17
17
|
FROM
|
|
18
18
|
item
|
|
19
|
+
GROUP BY
|
|
20
|
+
item
|
|
19
21
|
) mxitem
|
|
20
22
|
join item mxpriceitem ON
|
|
21
23
|
mxitem.id = mxpriceitem.id
|
|
@@ -25,11 +27,11 @@
|
|
|
25
27
|
|
|
26
28
|
```SQL
|
|
27
29
|
SELECT
|
|
28
|
-
|
|
30
|
+
max_item.item,
|
|
29
|
-
|
|
31
|
+
max_price,
|
|
30
|
-
|
|
32
|
+
max_date,
|
|
31
|
-
|
|
33
|
+
min_price,
|
|
32
|
-
|
|
34
|
+
min_date
|
|
33
35
|
FROM
|
|
34
36
|
(
|
|
35
37
|
SELECT
|
|
@@ -43,6 +45,8 @@
|
|
|
43
45
|
MAX(price) max_price
|
|
44
46
|
FROM
|
|
45
47
|
item
|
|
48
|
+
GROUP BY
|
|
49
|
+
item
|
|
46
50
|
) mxitem
|
|
47
51
|
JOIN item mxpriceitem ON
|
|
48
52
|
mxitem.id = mxpriceitem.id
|
|
@@ -59,6 +63,8 @@
|
|
|
59
63
|
MIN(price) min_price
|
|
60
64
|
FROM
|
|
61
65
|
item
|
|
66
|
+
GROUP BY
|
|
67
|
+
item
|
|
62
68
|
) mnitem
|
|
63
69
|
JOIN item mnpriceitem ON
|
|
64
70
|
mnitem.id = mnpriceitem.id
|