**Task:** 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{$#,###.##}.
We need a query to select from one table based on a column value in other table.
**alternative 1 : inner join**```sqlselect    A.*from    loans Ainner join employees B    on A.employee_id = B.employee_idwhere    B.city = 'El Paso';```
**alternative 2: correlated sub select**
```sqlselect    A.*from    loans Awhere    A.employee_id in (        select B.employee_id from employees B where B.city = 'El Paso')```
The alternative 1 is faster in caluclation time for me.
**Final sum of loans:**```sqlselect sum(A.balance) from loans A inner join employees B on A.employee_id = B.employee_id where B.city = 'El Paso'; ```