SELECT row_number() over (order by year desc) as [S.No],
     SUM([values]) as Total, year
 FROM [table]
 GROUP BY Year