Boom
Challenge:
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.
Solution:
The Ghost Town thread linked in the challenge description is a discussion of targeting "Baby Boomers".
To answer the challenge we need to count the number of customers who were born between 1946 and 1964:
mysql> select count(*) from (select *, str_to_date(dob, '%m/%d/%Y') as d from customers) as t1 where t1.d < '1965-01-01' and t1.d > '1946-01-01' order by d;
count(*)
2809
The accepted flag was, flag{2809}
Leave a comment