回答編集履歴
1
追記
answer
CHANGED
|
@@ -12,4 +12,15 @@
|
|
|
12
12
|
) tmp
|
|
13
13
|
group by
|
|
14
14
|
date(create_date)
|
|
15
|
+
```
|
|
16
|
+
追記
|
|
17
|
+
---
|
|
18
|
+
SVC34さんのを見て改良型を。
|
|
19
|
+
```SQL
|
|
20
|
+
select date(create_date) as 日付
|
|
21
|
+
, count(distinct user_id, in_count) as 人数
|
|
22
|
+
from user_history
|
|
23
|
+
where node not like '%2_HPから選ぶ%'
|
|
24
|
+
group by
|
|
25
|
+
date(create_date)
|
|
15
26
|
```
|