sqlserver 根据（年-月）日期获取订单的成交价

SELECT  DATENAME(YEAR, a.CreateTime)as Years,DATENAME(MONTH, a.CreateTime) AS XName,sum(JE+ PacketMoney)as Val
                        from Appointment a
                        where a.zt=6
                        GROUP BY DATENAME(YEAR, a.CreateTime),DATENAME(MONTH, a.CreateTime);