Tags: mysql
Rating:
# El Paso
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**.
## Query
```sql
SELECT SUM(balance) as dollar_value
FROM `loans` AS lo
INNER JOIN customers as cu on cu.cust_id = lo.cust_id
INNER JOIN employees as em on em.employee_id = lo.employee_id
WHERE em.city = "El Paso"
```
### Query Result
| dollar_value |
|--------------|
| 877401.00 |
## Flag
`flag{$877,401.00}`
