回答編集履歴
1
修正
test
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
|
|
11
11
|
from (
|
|
12
12
|
|
|
13
|
-
select 名称, max(産地別最終入荷日) as 最終入荷日, 国内産地, 国外産地
|
|
13
|
+
select 名称, max(産地別最終入荷日) as 最終入荷日, max(国内産地) as 国内産地, max(国外産地) as 国外産地
|
|
14
14
|
|
|
15
15
|
from (
|
|
16
16
|
|
|
@@ -40,7 +40,7 @@
|
|
|
40
40
|
|
|
41
41
|
) step2
|
|
42
42
|
|
|
43
|
-
group by 名称
|
|
43
|
+
group by 名称
|
|
44
44
|
|
|
45
45
|
) step3
|
|
46
46
|
|