sql - Count where age is going to be 60 in next 3 years onward -

i have count teachers ages going 60 @ june 2013, june 2014 , june 2015. details : @ 2013 there 1 teacher 2014 there 5 teachers same etc.

i don't know how 3 next years june , count number of teachers age 60 @ june 2013, june 2014 , june 2015.

here table:

teachername         dateofbirth               teacherage    june2013    june2014    june2015 s. khalid salim     1958-03-23 00:00:00.000   55             zubaida begum       1976-08-01 00:00:00.000   36             tanzeem akhtar      1974-09-25 00:00:00.000   38             maryam bibi         1982-08-18 00:00:00.000   30             rabia tabassum      1976-11-10 00:00:00.000   36     

here query:

select  teachername, dateofbirth,   datediff(mm, dateofbirth, getdate()) / 12 teacherage,   ''  june2013(countteachers) , '' june2014(countteachers), '' june2015(countteachersonlywhoseagewillbe60atjune2015) teachers 

try this:

declare @dob  datetime, @june2013date datetime, @june2014date datetime set @dob='1980-01-09 00:00:00' set @june2013date='2013-06-01 00:00:00' set @june2014date='2014-06-01 00:00:00'   select datediff(hour,@dob,getdate())/8766  age,     datediff(hour,@dob,@june2013date)/8766 june2013age,     datediff(hour,@dob,@june2014date)/8766 june2014age 

it should return this:

age         june2013age june2014age ----------- ----------- ----------- 33          33          34