6 lines
200 B
SQL
6 lines
200 B
SQL
with '2021-09-15' as date
|
|
select owner_name, uniqExact(`#account_id`) as n
|
|
from xiangsu.event
|
|
where `#event_name` = 'create_account'
|
|
and toDate(addHours(`#event_time`, 8)) = date
|
|
group by owner_name |