This should get you the data you're looking for:
SELECT
up.`USER_ID` , u.`USER_DISPLAY_NAME`
FROM
`ubbt_USERS` AS u, `ubbt_USER_PROFILE` AS up
WHERE
up.`USER_BIRTHDAY` <= (now()-31557600) AND
up.`USER_ID`!='1' AND
u.`USER_ID` = up.`USER_ID`
Though, adding a user to a group based on that query is more complicated.