select users as per their years completion date current year

[Arup Rakshit <aruprakshit@xxxxxxxxxxxxxx>]

Suppose I have users table. I have a joining_date. Now I only want those users who completed 5 years, 10 years, and in which date they completed. 

Example:

Out of all users, suppose below users only -

Foo_1 on 24/1/2014 completed 10 years

Foo_2 on 2/2/2014 completed  10 years

Foo_3 on 14/3/2014 completed 15 years

Foo_4 on 21/3/2014 completed 5 years

They should come in the output 

 

Regards,
Arup Rakshit