SELECT CONVERT( VARCHAR ( 7 ), , 120 ) AS FUNDDEALDATE,SUM ( d.fundsum ) AS TRADITIONGETMONEY FROMODBusiness.DBO.ONCONTRACT C LEFT JOIN ODBusiness.DBO.OnContractFee D ON C.CODE=D.ContractCodeWHEREDATEDIFF( MONTH, d.FUNDDEALDATE,'${dateinmonth(CONCATENATE(year,"-",month,"-1"),-1)}' ) <= 11AND CODE NOT LIKE ('%总包%')GROUP BYCONVERT ( VARCHAR ( 7 ), , 120 )