Find birthday for a date range

SELECT `last_name`, `first_name`, birth_date
FROM `employees`
WHERE DATE_ADD(birth_date, INTERVAL (2017 - YEAR(birth_date)) YEAR) >=  STR_TO_DATE('2017-07-29', '%Y-%m-%d')
  AND DATE_ADD(birth_date, INTERVAL (2017 - YEAR(birth_date)) YEAR) <=  STR_TO_DATE('2017-08-04', '%Y-%m-%d')