Practically the same question as this.
select p.personID
,p.lastname
,p.firstname
,p.birthdatetr
,p.deathdatetr
,p.deathplace
from tng_people as p
left outer join tng_medialinks as ml
on ml.personID=p.personID
and ml.eventID='DEAT'
where p.deathdatetr>=cast('1910-01-01' as date)
and p.deathdatetr< cast('1966-01-01' as date)
and p.burialplace like "%missouri%"
and ml.eventID is null
order by p.lastname
,p.firstname
;