質問編集履歴
4
テーブルのレコード数追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -163,3 +163,5 @@
|
|
|
163
163
|
###環境
|
|
164
164
|
|
|
165
165
|
macローカル PostgreSQL 13.4(pgadmin4)
|
|
166
|
+
|
|
167
|
+
テーブルのレコード数はそれぞれ240万件ほど（レコード数は同じ）です。
|
3
環境を追記しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -157,3 +157,9 @@
|
|
|
157
157
|
where rfm_analytics_raw_total.会員ID = t1.会員ID;
|
|
158
158
|
|
|
159
159
|
```
|
|
160
|
+
|
|
161
|
+
|
|
162
|
+
|
|
163
|
+
###環境
|
|
164
|
+
|
|
165
|
+
macローカル PostgreSQL 13.4(pgadmin4)
|
2
sql内のカラム名修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -106,7 +106,7 @@
|
|
|
106
106
|
|
|
107
107
|
from uriage_total tt1
|
|
108
108
|
|
|
109
|
-
join rfm_analytics_raw_total tt2 using(
|
|
109
|
+
join rfm_analytics_raw_total tt2 using(会員ID)
|
|
110
110
|
|
|
111
111
|
group by tt2.会員ID
|
|
112
112
|
|
|
@@ -144,16 +144,16 @@
|
|
|
144
144
|
|
|
145
145
|
from (
|
|
146
146
|
|
|
147
|
-
select tt2.
|
|
147
|
+
select tt2.会員ID, max(tt1.予約日) as maxdate
|
|
148
148
|
|
|
149
149
|
from uriage_total tt1
|
|
150
150
|
|
|
151
|
-
join rfm_analytics_raw_total tt2 using(
|
|
151
|
+
join rfm_analytics_raw_total tt2 using(会員ID)
|
|
152
152
|
|
|
153
|
-
group by tt2.
|
|
153
|
+
group by tt2.会員ID
|
|
154
154
|
|
|
155
155
|
) as t1
|
|
156
156
|
|
|
157
|
-
where rfm_analytics_raw_total.
|
|
157
|
+
where rfm_analytics_raw_total.会員ID = t1.会員ID;
|
|
158
158
|
|
|
159
159
|
```
|
1
実現したいことのアウトプットイメージのテーブルの値が間違っていました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -38,11 +38,11 @@
|
|
|
38
38
|
|
|
39
39
|
|0001|2019/2/14|A002|01|3|15000|2019/2/14|2|
|
|
40
40
|
|
|
41
|
-
|0002|2019/1/10|A001|01|2|8000|2019/3/24|
|
|
41
|
+
|0002|2019/1/10|A001|01|2|8000|2019/3/24|3|
|
|
42
42
|
|
|
43
|
-
|0002|2019/2/20|A002|01|3|15000|
|
|
43
|
+
|0002|2019/2/20|A002|01|3|15000|2019/3/24|3|
|
|
44
44
|
|
|
45
|
-
|0002|2019/3/24|A002|01|3|10000|
|
|
45
|
+
|0002|2019/3/24|A002|01|3|10000|2019/3/24|3|
|
|
46
46
|
|
|
47
47
|
|
|
48
48
|
|
|
@@ -74,9 +74,15 @@
|
|
|
74
74
|
|
|
75
75
|
|:--|:--:|:--:|:--:|:--:|:--:|:--:|:--:|:--:|:--:|
|
|
76
76
|
|
|
77
|
-
|0001|2019/1/1|A001|01|2|10000|2019/2/14|2|25000|
|
|
77
|
+
|0001|2019/1/1|A001|01|2|10000|2019/2/14|2|25000|2|
|
|
78
78
|
|
|
79
|
-
|0001|2019/2/14|A002|01|3|15000|2019/2/14|2|25000|
|
|
79
|
+
|0001|2019/2/14|A002|01|3|15000|2019/2/14|2|25000|2|
|
|
80
|
+
|
|
81
|
+
|0002|2019/1/10|A001|01|2|8000|2019/3/24|3|33000|1|
|
|
82
|
+
|
|
83
|
+
|0002|2019/2/20|A002|01|3|15000|2019/3/24|3|33000|1|
|
|
84
|
+
|
|
85
|
+
|0002|2019/3/24|A002|01|3|10000|2019/3/24|3|33000|1|
|
|
80
86
|
|
|
81
87
|
|
|
82
88
|
|