SELECT DATE(q."time") AS data, 
       SUM(CASE 
             WHEN ( q.event IN ( 'ABANDON', 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                  ) THEN 
             1 
             ELSE 0 
           END)       AS recebidas, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) ) THEN 1 
             ELSE 0 
           END)       AS atendidas, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' ) THEN 1 
             ELSE 0 
           END)       AS abandonadas, 
       CEIL(AVG(CASE 
                  WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) ) THEN 
                  CAST(data2 AS INT4) 
                  ELSE NULL 
                END)) AS tma, 
       CEIL(AVG(CASE 
                  WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) ) THEN 
                  CAST(data1 AS INT4) 
                  ELSE NULL 
                END)) AS tme, 
       CEIL(AVG(CASE 
                  WHEN ( q.event = 'ABANDON' ) THEN CAST(data3 AS INT4) 
                  ELSE NULL 
                END)) AS tmAbandono, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) ) THEN 
             CAST(data2 AS INT4) 
             ELSE 0 
           END)       AS tempoFalando, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                    AND CAST(q.data1 AS INT4) <= :a1 ) THEN 1 
             ELSE 0 
           END)       AS sla1_60S, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                    AND CAST(q.data1 AS INT4) > :a1 
                    AND CAST(q.data1 AS INT4) <= :a2 ) THEN 1 
             ELSE 0 
           END)       AS sla2_120S, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                    AND CAST(q.data1 AS INT4) > :a2 
                    AND CAST(q.data1 AS INT4) <= :a3 ) THEN 1 
             ELSE 0 
           END)       AS sla3_180S, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                    AND CAST(q.data1 AS INT4) > :a3 
                    AND CAST(q.data1 AS INT4) <= :a4 ) THEN 1 
             ELSE 0 
           END)       AS sla4_240S, 
       SUM(CASE 
             WHEN ( q.event IN ( 'COMPLETECALLER', 'COMPLETEAGENT' ) 
                    AND CAST(q.data1 AS INT4) > :a5 ) THEN 1 
             ELSE 0 
           END)       AS sla5_M240S, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' 
                    AND CAST(q.data3 AS INT4) <= :a1 ) THEN 1 
             ELSE 0 
           END)       AS abandono1_60S, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' 
                    AND CAST(q.data3 AS INT4) > :a1 
                    AND CAST(q.data3 AS INT4) <= :a2 ) THEN 1 
             ELSE 0 
           END)       AS abandono2_120S, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' 
                    AND CAST(q.data3 AS INT4) > :a2 
                    AND CAST(q.data3 AS INT4) <= :a3 ) THEN 1 
             ELSE 0 
           END)       AS abandono3_180S, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' 
                    AND CAST(q.data3 AS INT4) > :a3 
                    AND CAST(q.data3 AS INT4) <= :a4 ) THEN 1 
             ELSE 0 
           END)       AS abandono4_240S, 
       SUM(CASE 
             WHEN ( q.event = 'ABANDON' 
                    AND CAST(q.data3 AS INT4) > :a5 ) THEN 1 
             ELSE 0 
           END)       AS abandono5_M240S, 
       SUM(CASE 
             WHEN ( q.event = 'PAUSE' 
                    AND q.queuename = :fila ) THEN 1 
             ELSE 0 
           END)       AS qtdPausa, 
       SUM(CASE 
             WHEN ( q.event = 'UNPAUSE' 
                    AND q.queuename = :fila ) THEN 1 
             ELSE 0 
           END)       AS qtdCancelaPausa 
FROM   queue_log q 
WHERE  DATE(q.time) BETWEEN DATE(:inicio) AND DATE(:fim) 
       AND q.queuename = :fila
GROUP  BY DATE(q.time) 
ORDER  BY DATE(q.time)