11-1-1-1

insert into SF_CHA_YS
(SAAS, ysje, ztbz, sfqj, xsid, beizhu)
(select ‘49557147X’, sum(V_04), ‘0’,
‘D3618A9718004D6296AA5234611F0F74’,
‘E9C551E626744F9482F3429974CD9B02’,
V_08
from sf_sys_dr S
where S.bm = ‘S03’ and S.czr = ‘charge’ and S.SAAS = ‘49557147X’
group by V_09, V_11, V_01, ‘49557147X’, v_08)

/SELECT GID FROM SF_CHA_SFQJ Z WHERE Z.QJMC = ‘2019-2020秋’ and Z.SAAS = ‘49557147X’
SELECT GID FROM SF_EDU_XS Z WHERE (Z.SFZH =‘420922200508121439’ OR Z.XH =‘C202017A0009’) and Z.SAAS = ‘49557147X’/