SQL запрос на поиск пользователей с фильтром на возраст и пол?

SELECT * 
FROM Users
WHERE 
YEAR(date) - YEAR(birthday) - (DATE_FORMAT(date, '%m%d') < DATE_FORMAT(birthday, '%m%d'))<X
AND 
gender = "Male/Female"

возрасту…(сегодня)-('birthday')=лет

CAST( DATEDIFF( Year, BirthDay, ISNULL( DeathDay, GETDATE())) + ( SIGN ( DATEDIFF ( DAY, BirthDay, DATEADD ( YEAR, YEAR( BirthDay ) - YEAR( ISNULL( DeathDay, GETDATE()) ), ISNULL( DeathDay, GETDATE())))) - 1 ) / 2 AS VARCHAR)