Untitled

SELECT
SUM(FT.TOT_AMT),
MIN(BS.START_DT),
MAX(BS.END_DT)
FROM
CI_BSEG BS,
CI_FT FT,
CI_SA_TYPE SAT,
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 = 'GMO '
AND SA.SA_TYPE_CD = 'ERES '
AND FT.ARS_DT BETWEEN '2022-02-14'
AND date'2023-02-14'
AND (('9814280000'<> ' '
AND SA.CHAR_PREM_ID = '9814280000')
OR
('9814280000'= ' '
AND SA.SA_ID = '1029194632'))