sql select upcoming birthdays

1SELECT 
2  BRTHDATE AS BIRTHDAY
3 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25) AS AGE_NOW
4 ,FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW
5FROM 
6  "Database name".dbo.EMPLOYEES EMP
7WHERE 1 = (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()+7) / 365.25))
8          -
9          (FLOOR(DATEDIFF(dd,EMP.BRTHDATE,GETDATE()) / 365.25))
10