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

with c as(
select order_date,count(*) as order_count
from(
select user_id,date(order_time) as order_date
from order_tb
group by user_id,order_date) as a
group by order_date),

d as (
select visit_date,count(*) as visit_count
from(
select user_id,date(visit_time) as visit_date
from visit_tb
group by user_id,visit_date) as b 
group by visit_date)

select order_date as date ,concat(round((order_count/visit_count)*100,1),'%') as cr
from  c 
join d 
on c.order_date = d.visit_date 
order by date