select count(distinct user_id) from
(
    select user_id,min(to_char(create_date),'yyyymmdd')
    from user_order
    --如果有分区的话，需要加上最新的分区 having min(to_char(create_date),'yyyymmdd') = '20180522' )tt