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

/*每日转化率，百分数形式，保留一位小数*/
with
 t1 as (
    select date(order_time) as o_date,count(distinct user_id) as 当日下单人数
    from order_tb
    group by date(order_time)
),
t2 as(
    select date(visit_time) as v_date,count(distinct user_id) as 当日访问人数
    from visit_tb
    group by date(visit_time) 
)

select   t1.o_date  as date,
        concat(round(100 * 当日下单人数/当日访问人数,1),'%') as cr
from t1 
right join t2 on t1.o_date =t2.v_date