SELECT COUNT(DISTINCT ETS_SITE_ID) OVER (PARTITION BY EXTERNAL_INVOICE_ID) COL_DISP_CNT,
      SUM(TOTAL_AMOUNT) OVER (PARTITION BY EXTERNAL_INVOICE_ID) COL_DISP_TTL_AMT,
      AVG(TOTAL_AMOUNT) OVER (PARTITION BY EXTERNAL_INVOICE_ID) COL_DISP_AVG_AMT
    FROM  TXN_INVOICE_DTLS
        WHERE  APPROVAL_FLAG = -1
            AND EXTERNAL_INVOICE_ID IS NOT NULL
            AND CIRCLE_ID=24
            AND BILL_MONTH BETWEEN 201801 AND 201811;