Rating:

# Boom

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{#}`

Use the MySQL database dump from **Body Count**.

## Background
For this challenge we were given a hint that DEADFACE would be targeting low-hanging fruit, from this we can deduce they're going to target the generally less technically inclinded members of society, the elderly. Finding the posts on Ghost Town confirms this.
https://ghosttown.deadface.io/t/who-are-we-hitting-first/60/7

> @alitevlin 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.

## Query
Let's write a query which includes all those defined as Baby-Boomers (as supplied by a post in GT)
>_"Baby boomer" is a term used to describe a person who was born between 1946 and 1964_

```sql
SELECT COUNT(cust_id)
FROM `customers`
WHERE STR_TO_DATE(dob, '%m/%d/%Y')
BETWEEN STR_TO_DATE('01/01/1946', '%m/%d/%Y') AND STR_TO_DATE('12/31/1964', '%m/%d/%Y')
```

### Query Results
The above query gave us a count of 2809

## Flag
`flag{2809}`