回答編集履歴

1

追記

2016/02/24 04:42

投稿

ngyuki
ngyuki

スコア4514

test CHANGED
@@ -99,3 +99,47 @@
99
99
  group by M.last_date;
100
100
 
101
101
  ```
102
+
103
+
104
+
105
+ ----
106
+
107
+
108
+
109
+ > 累積の新規ユーザ数の左隣りに、その月の新規ユーザ数も表示させたいのですが
110
+
111
+
112
+
113
+ ```sql
114
+
115
+ select
116
+
117
+ date_format(M.last_date, '%Y/%m') as mon,
118
+
119
+ count(*) as tcnt,
120
+
121
+ sum(last_day(M.last_date) = last_day(U.user_date)) as mcnt
122
+
123
+ from (
124
+
125
+ select distinct last_day(access_day) as last_date from access_record
126
+
127
+ ) as M
128
+
129
+ join (
130
+
131
+ select user_id, min(access_day) as user_date from access_record group by user_id
132
+
133
+ ) as U
134
+
135
+ where M.last_date >= U.user_date
136
+
137
+ group by M.last_date;
138
+
139
+ ```
140
+
141
+
142
+
143
+
144
+
145
+