Untitled

SELECT
SUM(FT.TOT_AMT),
MIN(BS.START_DT),
MAX(BS.END_DT)
FROM
CISADM.CI_BSEG BS,
CISADM.CI_FT FT,
CISADM.CI_SA_TYPE SAT,
CISADM.CI_SA SA
WHERE
BS.BSEG_ID = FT.SIBLING_ID
AND FT_TYPE_FLG IN ('BS' , 'BX')
AND SA.SA_ID = BS.SA_ID
AND SA.CIS_DIVISION = SAT.CIS_DIVISION
AND SA.SA_TYPE_CD = SAT.SA_TYPE_CD
AND BS.BSEG_STAT_FLG = '50'
AND SA.CIS_DIVISION = 'WSTRC '
AND SA.SA_TYPE_CD = 'ERES '
AND FT.ARS_DT BETWEEN TO_DATE('30-07-2023', 'DD-MM-YYYY')
AND TO_DATE('30-07-2024', 'DD-MM-YYYY')
AND BS.START_DT BETWEEN TO_DATE('30-07-2023', 'DD-MM-YYYY')
AND TO_DATE('30-07-2024', 'DD-MM-YYYY')
AND (('7847390000'<> ' '
AND SA.CHAR_PREM_ID = '7847390000')
OR
('7847390000'= ' '
AND SA.SA_ID = '1887942995'))
;