El Paso

Challenge:

The regional manager for the El Paso branch of De Monne Financial is afraid his customers might be targeted for further attacks. He would like you to find out the dollar value of all outstanding loan balances issued by employees who live in El Paso. Submit the flag as flag{$#,###.##}.

Use the MySQL database dump from Body Count.

Solution:

select sum(balance) from loans where employee_id in (select employee_id from employees where city = 'El Paso');
+--------------+
| sum(balance) |
+--------------+
|    877401.00 |
+--------------+

The accepted flag was: flag{$877,401.00}