select count(t.user_id)
from (
select user_id,
count(distinct user_id) as c,
min(start_mills) as ms,
collect_set(source_channel)[0] as sc
from b2cdc.p0_log_page
where date >= 20201201 and date <= 20201231
group by user_id
) t
where t.sc=4
是這樣求的某渠道首次訪問id數,接著時間差不會寫了
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/253707.html
標籤:應用實例
上一篇:求問上表怎么轉成下表這樣的格式啊
