Untitled
user_3592770
plain_text
16 days ago
1.0 kB
3
Indexable
WITH cepal_answered AS ( SELECT COUNT(DISTINCT dialerid) AS cepal_count FROM `p-cdh`.primaryactive.dialer WHERE ringtimeduration <= 180 AND talktimeduration >= 1 AND calltypecode = 'INBOUND' AND IsActiveFlag = 'true' ), ext_answered AS ( SELECT COUNT(DISTINCT dialerid) AS ext_count FROM `p-cdh`.primaryactive.dialer WHERE ringtimeduration > 180 AND ringtimeduration <= 240 AND talktimeduration >= 1 AND calltypecode = 'INBOUND' AND IsActiveFlag = 'true' ), total_answered AS ( SELECT (SELECT cepal_count FROM cepal_answered) + (SELECT ext_count FROM ext_answered) AS total_answered_count ), total_calls AS ( SELECT COUNT(DISTINCT dialerid) AS total_count FROM `p-cdh`.primaryactive.dialer WHERE calltypecode = 'INBOUND' AND IsActiveFlag = 'true' ) SELECT ROUND(100.0 * (SELECT total_answered_count FROM total_answered) / (SELECT total_count FROM total_calls), 2) AS percentage_answered FROM dual;
Editor is loading...
Leave a Comment