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

with t1 as (
	select count(distinct user_id) as pv , date(visit_time) `pv_date` from visit_tb vt group by date(visit_time)
),
t2 as (
	select count(distinct user_id) as `order` , date(order_time) `order_date` from order_tb vt group by date(order_time)
),
t3 as (
	select * from t1 left join t2 on t1.pv_date = t2.order_date
)
select pv_date as `date`,concat(round(`order`/pv*100,1),'%') as cr from t3 ;