SELECT Sum(Balance), cities.Name, countries.Name FROM testdb.accounts join testdb.cities on ClientId = (select Id FROM testdb.bank_clients where CityId = cities.Id) join testdb.countries on ClientId = (select Id FROM testdb.bank_clients where CountryId = countries.Id) group by cities.Name