Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. SELECT calls.created,
  2. sum(
  3. CASE WHEN calls.use_call_cost = FALSE
  4. THEN calls."CallDuration"
  5. END
  6. ) / 60 * calls.cost,
  7. -- +
  8. -- count(
  9. -- CASE WHEN calls.use_call_cost = TRUE
  10. -- THEN calls.cost
  11. -- END
  12. -- ) * calls.cost,
  13. calls.cost
  14. FROM (
  15. SELECT
  16. date_trunc('day', "Timestamp") AS created,
  17. "CallDuration",
  18. CASE
  19. WHEN descr.use_call_cost = TRUE
  20. THEN descr.call_cost
  21. WHEN descr.use_call_cost = FALSE
  22. THEN descr.minute_cost
  23. END AS cost,
  24. use_call_cost
  25. FROM cdr_cdrblocked
  26. JOIN cdr_description descr ON cdr_cdrblocked."Description" = descr.prefix
  27. WHERE "CallDuration" NOTNULL
  28. AND is_blocked = TRUE
  29. AND DATE("Timestamp") BETWEEN '01.11.2017' AND '23.11.2017'
  30. ) calls
  31. GROUP BY calls.created, calls.cost ORDER BY calls.created
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement