Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT calls.created,
- sum(
- CASE WHEN calls.use_call_cost = FALSE
- THEN calls."CallDuration"
- END
- ) / 60 * calls.cost,
- -- +
- -- count(
- -- CASE WHEN calls.use_call_cost = TRUE
- -- THEN calls.cost
- -- END
- -- ) * calls.cost,
- calls.cost
- FROM (
- SELECT
- date_trunc('day', "Timestamp") AS created,
- "CallDuration",
- CASE
- WHEN descr.use_call_cost = TRUE
- THEN descr.call_cost
- WHEN descr.use_call_cost = FALSE
- THEN descr.minute_cost
- END AS cost,
- use_call_cost
- FROM cdr_cdrblocked
- JOIN cdr_description descr ON cdr_cdrblocked."Description" = descr.prefix
- WHERE "CallDuration" NOTNULL
- AND is_blocked = TRUE
- AND DATE("Timestamp") BETWEEN '01.11.2017' AND '23.11.2017'
- ) calls
- GROUP BY calls.created, calls.cost ORDER BY calls.created
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement