SELECT msisdn ,
                 MIN (Diff)  Min_BtwCall,
                 TRUNC ( (AVG (Diff)) ) Avg_BtwCall,
                 MAX (Diff)  Max_BtwCall--,
                        FROM ( WITH T2
                       AS (SELECT  DISTINCT START_TIMESTAMP AS START_TIMESTAMP,
                                s_p_number_address ,
                                  ROW_NUMBER()
                                  OVER (PARTITION BY s_p_number_address
                                        ORDER BY  START_TIMESTAMP ASC)
                                     AS RANK
                             FROM (SELECT  DISTINCT  call_date AS START_TIMESTAMP,
                             msisdn AS s_p_number_address
                                FROM AGG_MSC_MSISDN
                                    WHERE     PRODUCT = 'VOIX'
                                        AND EVENT_DIRECTION = '1'
                                          AND ENTRY_DATE_fct >= TRUNC (SYSDATE) -113
                                        AND  ENTRY_DATE_fct < TRUNC (SYSDATE) -83
                                        AND call_date >= TRUNC (SYSDATE) -113
                                        AND  call_date < TRUNC (SYSDATE) -83
                                       ) ORDER BY RANK
                                  )
                  SELECT T1.s_p_number_address AS msisdn,
                         T1.RANK AS RANK,
                         T2.RANK AS RANK,
                         T1.START_TIMESTAMP AS START_TIMESTAMP,
                        T2.START_TIMESTAMP AS START_TIMESTAMP,
                         (  T2.START_TIMESTAMP
                          -   T1.START_TIMESTAMP
                            )
                            AS Diff
                    FROM (SELECT  DISTINCT START_TIMESTAMP AS START_TIMESTAMP,
                                s_p_number_address ,
                                  ROW_NUMBER()
                                  OVER (PARTITION BY s_p_number_address
                                        ORDER BY  START_TIMESTAMP ASC)
                                     AS RANK
                             FROM (SELECT  DISTINCT  call_date AS START_TIMESTAMP,
                             msisdn AS s_p_number_address,
                                       event_direction
                                FROM AGG_MSC_MSISDN
                                    WHERE     PRODUCT = 'VOIX'
                                        AND EVENT_DIRECTION = '1'
                                          AND ENTRY_DATE_fct >= TRUNC (SYSDATE) -113
                                        AND  ENTRY_DATE_fct < TRUNC (SYSDATE) -83
                                        AND call_date >= TRUNC (SYSDATE) -113
                                        AND  call_date < TRUNC (SYSDATE) -83
                                       ) ORDER BY RANK
                                  ) T1
                         LEFT JOIN T2
                            ON   T1.RANK +1  = T2.RANK
                               AND T1.s_p_number_address =
                                      T2.s_p_number_address
            )
          WHERE diff IS NOT NULL
          AND msisdn IN(SELECT '216'||served_account FROM ROW_INCCN_CONSO_8)
       GROUP BY msisdn