SELECT *
FROM PL_TRADEDETAIL A
			LEFT JOIN PL_MASTER M ON A.PLAN_ID =M.PLAN_ID
			LEFT JOIN CM_GOODS G ON A.GOODS_ID=G.GD_ID
			LEFT JOIN CM_GOODSTYPE GT ON GT.GD_TYPE_CODE IN (SELECT G.GD_TYPE_CODE FROM WSISPLIT(G.GD_CODE,'.') J JOIN CM_GOODSTYPE G ON G.GD_TYPE_CODE = J.VALUE)
			WHERE 1=1
			AND (M.YEAR =  CONVERT(INT,'2023'))

SELECT SUM(A.AMT_APP)/1000000000
FROM PL_TRADEDETAIL A
			LEFT JOIN PL_MASTER M ON A.PLAN_ID =M.PLAN_ID
			LEFT JOIN CM_GOODS G ON A.GOODS_ID=G.GD_ID
			LEFT JOIN CM_GOODSTYPE GT ON GT.GD_TYPE_CODE IN (SELECT G.GD_TYPE_CODE FROM WSISPLIT(G.GD_CODE,'.') J JOIN CM_GOODSTYPE G ON G.GD_TYPE_CODE = J.VALUE)
			WHERE 1=1
			AND (M.YEAR =  CONVERT(INT,'2023'))