Multiple Category

                Never    
SQL
        
Download Raw Clone Report Copy 
select 
month_0_multi_category,
count( distinct buyer_id ) as totalusers
from
(select 
buyer_id,
first_order_at,
count(distinct case when date(payed_at) between date(first_order_at) and DATE_ADD(DATE (first_order_at),INTERVAL 29 DAY) then category_slug else null end) as month_0_multi_category,
count(distinct case when date(payed_at) between date(first_order_at) and DATE_ADD(DATE (first_order_at),INTERVAL 29 DAY) then order_id else null end) as month_0
from shared.orders
group by 1,2
order by 1 desc,2 desc) as t2
group by 1
order by 1

Raw Text

Recent Public Pastes