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

select df as date,
    concat(round(dan/fang*100,1),'%') cr
from 
    (select date_format(order_time,'%Y-%m-%d') df,
            count(distinct user_id) dan  --排除一个用户多次下单的情况
    from order_tb 
    group by df) t1
join 
    (select date_format(visit_time,'%Y-%m-%d')  df2,
    count(distinct user_id) fang    -- 排除一个用户多次访问的情况
    from visit_tb
    group by df2
    )  t2
on t1.df =t2.df2
group by df
order by df asc