Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FROM (
- SELECT toStartOfMonth(crm_income_dt) as dt,
- sum(application_cnt) as "Заявки",
- sum(opened_accounts_cnt) as "Открытых счетов",
- 100* "Открытых счетов"/"Заявки" as "% от заявки",
- sum(util_100_cnt) as "Утилизаций 100",
- 100* "Утилизаций 100"/"Открытых счетов" as "% от счета",
- sum(if(isNaN(Activations), 0, Activations)) as "Активаций промокода",
- 100* "Активаций промокода"/ "Утилизаций 100" as "% от утилизаций"
- FROM analytics.tinkoff_activations_daily
- WHERE crm_income_dt >= $from
- group by dt
- )
- ) t using dt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement