select sum(qty), datename(year, date) as year1, datename(month, date) as month1 from table group by datename(year, date), datename(month, date)