题解 | 统计用户从访问到下单的转化率

with
    t1 as (
        select
            date(order_time) as date1,
            count(distinct user_id) as order_nums
        from
            order_tb
        group by
            date1
    ) ,
    
    t2 as (select
            date(visit_time) as date2,
            count(distinct user_id) as visit_nums
        from
            visit_tb
        group by
            date2
    )

    select
        t1.date1 as date,
        concat(round(t1.order_nums/t2.visit_nums*100,1),"%") as cr
    from t1
    join t2 on t1.date1=t2.date2
    order by date