clickhouse按天分组

select formatDateTime(create_time, '%Y-%m-%d') dat, count(*) coun
from user where 
group by formatDateTime(create_time, '%Y-%m-%d');