selecta.c_port_code,a.c_port_name,to_char(A1.D_ASTSTAT,'yyyy-mm-dd')D_ASTSTAT,CASEWHENA.C_DAT_CODEin('ASS_FOF','ASS_QDII')THENNVL(A11.DWJZ,A111.DWJZ)ELSEA1.DWJZENDDWJZ,CASEWHENA.C_DAT

selecta.c_port_code,a.c_port_name,to_char(A1.D_ASTSTAT,'yyyy-mm-dd')D_ASTSTAT,CASEWHENA.C_DAT_CODEin('ASS_FOF','ASS_QDII')THENNVL(A11.DWJZ,A111.DWJZ)ELSEA1.DWJZENDDWJZ,CASEWHENA.C_DAT

SELECTa.c_port_code,a.d_aststat,a.C_KM_NAMEDWJZFROMt_r_fr_aststatawhere(A.C_PORT_CODE='SGU520')anda.d_aststat=GETDAY_HDAY('CN',LAST_DAY(date'2023-07-01')+1,-1,'W&#