Rating:
**Task:** DEADFACE actors will be targeting customers they consider low-hanging fruit. Check out Ghost Town and see who they are targeting. Submit the number of target candidates as the flag: flag{#}
**Ghost Town thread:** We should try to find someone in their late 50s or in their 70s to target. They usually make better targets than younger folks. Try finding a baby boomer. Once you get the database from JC, hmu and we’ll find out which targets are best.
Let’s hit all boomers, not just Michigan. Go big or go home haha.
[https://www.investopedia.com/terms/b/baby_boomer.asp]https://www.investopedia.com/terms/b/baby_boomer.asp
So basically, we need to look for babyboomer' custumers, meaning they are born between 1946 and 1964.
Now it is time to start making sql requests.
```sql
SELECT email, STR_TO_DATE(dob,'%m/%d/%Y'),
datediff(now(), STR_TO_DATE(dob,'%m/%d/%Y'))/365.0 AS age,
datediff(STR_TO_DATE(dob,'%m/%d/%Y'), STR_TO_DATE('01/01/1946','%m/%d/%Y')) as diff
FROM `customers`
WHERE (datediff(STR_TO_DATE(dob,'%m/%d/%Y'), STR_TO_DATE('12/31/1964','%m/%d/%Y')) <= 0);
```
Answer: 2809 consumers.
