Advertisement
kirzecy670

Untitled

Dec 3rd, 2024 (edited)
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. FROM (
  2. SELECT toStartOfMonth(crm_income_dt) as dt,
  3. sum(application_cnt) as "Заявки",
  4. sum(opened_accounts_cnt) as "Открытых счетов",
  5. 100* "Открытых счетов"/"Заявки" as "% от заявки",
  6. sum(util_100_cnt) as "Утилизаций 100",
  7. 100* "Утилизаций 100"/"Открытых счетов" as "% от счета",
  8. sum(if(isNaN(Activations), 0, Activations)) as "Активаций промокода",
  9. 100* "Активаций промокода"/ "Утилизаций 100" as "% от утилизаций"
  10. FROM analytics.tinkoff_activations_daily
  11. WHERE crm_income_dt >= $from
  12. group by dt
  13. )
  14. ) t using dt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement