ID  amount      year
1   300 02-02-2010 00:00
2   400 02-02-2009 00:00
3   200 02-02-2011 00:00
4   300 22-02-2010 00:00
5   400 12-02-2009 00:00
6   500 22-02-2009 00:00
7   600 02-02-2006 00:00
8   700 02-07-2012 00:00
9   500 08-02-2012 00:00
10  800 09-02-2011 00:00
11  500 06-02-2010 00:00
12  600 01-02-2011 00:00
13  300 02-02-2019 00:00

Desired output

     Y1       Y2            Y3 ...........
  sum(amount)   sum(amount)   sum(amount)

Please suggest a approach

Y1 is the year part of the date so my result column would be 2006 2009 2010 2011 2012
600 1300 800 1900 1200

Thanks. DB- MYSQL, SQL SERVER

Thanks.