SQL Verschachtelung-Verständnisfrage

[Sandra]

Vielleicht so?

SELECT City.Population
    FROM City,Country C1
    WHERE City.Country=C1.Code AND City.Name != C1.Capital
           AND City.longitude - (SELECT City.longitude
            FROM City, Country
            WHERE City.Name=Country.Capital AND City.Country=Country.Code AND C1.Code=Country.Code
            ) <= 0.1
           AND City.longitude - (SELECT City.longitude
            FROM City, Country
            WHERE City.Name=Country.Capital AND City.Country=Country.Code AND C1.Code=Country.Code
            ) >= -0.1
    AND City.latitude - (SELECT City.latitude
     FROM City, Country
     WHERE City.Name=Country.Capital AND City.Country=Country.Code AND C1.Code=Country.Code
     ) >= -0.1
    AND City.latitude - (SELECT City.latitude
     FROM City, Country
     WHERE City.Name=Country.Capital AND City.Country=Country.Code AND C1.Code=Country.Code
    ) >= -0.1)