CODE EXAMPLE FOR SQL

mysql filter based on datediff

SELECT *
FROM myTable
WHERE birthdate >= 'date1' AND death <= 'date2' AND age > 17 AND age < 55;