Boom
Point 100
Description
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.
Hint
Link to discussion DEADFACE Member
https://ghosttown.deadface.io/t/who-are-we-hitting-first/60/10
Getting the flag
They are targeting boomer generation (1946-1964)
Now lets dig in the database and count.
select * from customers WHERE dob like '%1946';
select * from customers WHERE dob like '%1947';
select * from customers WHERE dob like '%1948';
select * from customers WHERE dob like '%1949';
...
select * from customers WHERE dob like '%1964';I take the values for each year and do the math on my own in an excelfile, because my sql is not so good 🙂
In the years 46 till 49 there were no result.
| Count | Year |
|---|---|
| 196 | 1950 |
| 168 | 1951 |
| 203 | 1952 |
| 184 | 1953 |
| 197 | 1954 |
| 209 | 1955 |
| 175 | 1956 |
| 173 | 1957 |
| 210 | 1958 |
| 202 | 1959 |
| 160 | 1960 |
| 182 | 1961 |
| 179 | 1962 |
| 182 | 1963 |
| 189 | 1964 |
| ------ | ------ |
| 2809 | Result |
flag{2809}