with begincheckout as
(select
distinct user_dim.app_info.app_instance_id as unikalni_begincheckout,
event.date as data
from
  empik-f0662.com_empik_empikapp_ANDROID.app_events_*,
   unnest(event_dim) as event,
   unnest(event.params) as params
where
event.name = 'begin_checkout'
and params.key = 'value'
and params.value.double_value > 0),

delivery as (select
distinct user_dim.app_info.app_instance_id as unikalni_delivery,
event.date as data
from
  empik-f0662.com_empik_empikapp_ANDROID.app_events_*,
   unnest(event_dim) as event,
   unnest(event.params) as params
where
event.name = 'cart_k1_btn_delivery'),

summary as (select
distinct user_dim.app_info.app_instance_id as unikalni_summary,
event.date as data
from
  empik-f0662.com_empik_empikapp_ANDROID.app_events_*,
   unnest(event_dim) as event,
   unnest(event.params) as params
where
event.name = 'cart_k2_btn_summary'),

buy as (select
distinct user_dim.app_info.app_instance_id as unikalni_kupili,
event.date as data
from
  empik-f0662.com_empik_empikapp_ANDROID.app_events_*,
   unnest(event_dim) as event,
   unnest(event.params) as params
where
event.name = 'cart_k3_btn_buy_cart')

select
b.data,
(case when unikalni_begincheckout is not null then unikalni_begincheckout else 0 end) as unique_begincheckout,
(case when unikalni_delivery is not null then unikalni_delivery else 0 end) as unique_delivery,
(case when unikalni_summary is not null then 1 else 0 end) as unique_summary,
(case when unikalni_kupili is not null then 1 else 0 end) as unique_kupili
FROM begincheckout b left join delivery d on b.unikalni_begincheckout = d.unikalni_delivery
  left join summary s on d.unikalni_delivery = s.unikalni_summary
  left join buy u on s.unikalni_summary = u.unikalni_kupili