```sqlselect    sum(A.balance), B.cityfrom    loans Ainner join employees B    on A.employee_id = B.employee_idwhere    B.state = 'CA' AND A.loan_type_id = 3GROUP BY B.cityORDER BY sum(A.balance) DESC;```
`flag{Oakland_$90,600.00}`