Data Analysis, Data, Data Science, Sql, Python.
the SQL code for e-commerce funnel calculation below to feel its complexity. with e1 as ( select uid,1 as step1,min(etime) as t1 from event where etime>= to_date(‘2021–01–10’) and etime<to_date(‘2021–01–25’) and eventtype=’eventtype1' and … group by 1), e2 as ( select uid,1 as step2,min(e1.t1) as