```sql
select
sum(A.balance), B.city
from
loans A
inner join employees B
on A.employee_id = B.employee_id
where
B.state = 'CA' AND A.loan_type_id = 3
GROUP BY B.city
ORDER BY sum(A.balance) DESC;
```

`flag{Oakland_$90,600.00}`

Original writeup (https://github.com/hhassen/writeup_deadface_2021/blob/main/sql.md).