I have employees table with date_of_join field

and I have employee_leaves table with the following fields:


the employee joined on 15 Feb 2011

I want to have a query showing the cound of leaves for every employee years based on his date_of_join

for example, if the employee joined on 15 Feb 2011 then the result will be like this:

Feb 2011 to feb 2012 ---- totals days: 21
Feb 2012 to feb 2013 ---- totals days: 26
Feb 2013 to feb 2014 ---- totals days: 8

where Feb to feb is the employee year so it's from 15 Feb to 14 Feb every year

can anyone help please?