Mysql query by Grouping Year horizontal

I am new to mysql query and i am stuck on getting query. Basically, i want the date to group as Year in horizontal way (column) as shown in Image below. enter image description here

Data are shown in image below:

enter image description here