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.

Ghost Town thread

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}

Published:

Updated:

Leave a comment