Select count (t.u ser_id)
The from (
The select user_id,
Count (distinct user_id) as c,
Min (start_mills) as ms,
Collect_set (source_channel) [0] as sc
The from b2cdc. P0_log_page
Where the date & gt;=20201201 and the date & lt;=20201231
Group by user_id
) t
Where t.s c=4
Is that a channel access id number for the first time, then the time can't write