質問編集履歴
3
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -103,3 +103,11 @@
|
|
|
103
103
|
2016-05-14 87 43
|
|
104
104
|
|
|
105
105
|
2016-05-13 65 47 33
|
|
106
|
+
|
|
107
|
+
|
|
108
|
+
|
|
109
|
+
COUNT(distinct(CASE WHEN t1.time＝ (t2.time)+1 THEN t1.id ELSE 0 END)) as 1day
|
|
110
|
+
|
|
111
|
+
とかにすると数字は出ますが、
|
|
112
|
+
|
|
113
|
+
上記のように表記されず、1日、3日ずつ行がずれてしまいます。。
|
2
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -76,6 +76,8 @@
|
|
|
76
76
|
|
|
77
77
|
Group by t1.time
|
|
78
78
|
|
|
79
|
+
order by t1.time DESC
|
|
80
|
+
|
|
79
81
|
|
|
80
82
|
|
|
81
83
|
この日ごとの新規ユーザーが1日後、3日後、7日後に
|
1
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -96,7 +96,7 @@
|
|
|
96
96
|
|
|
97
97
|
2016-05-16 48
|
|
98
98
|
|
|
99
|
-
2016-05-15 56
|
|
99
|
+
2016-05-15 56
|
|
100
100
|
|
|
101
101
|
2016-05-14 87 43
|
|
102
102
|
|