Did you even tried once?
Well, to start with, a logical way (date of death will not be filled and will be null until unless someone dies. Once dead, then only data is there!)
SELECT
id_Applicant,
name
FROM
Applicant
WHERE
date_of_death IS NOT NULL
:)
Now, if you need to use current date in your query based on some scenario, try by yourself. You almost have 90% of query with you.