1SELECT 
2  "country_larger_city" AS "country", 
3  "larger_city" AS "city", 
4  "pop_larger_city" AS "population_city", 
5  SUM("pop_smaller_city") AS "population_reachable",
6  ROUND(SUM("pop_smaller_city") / "pop_larger_city",2) AS "population_ratio",
7  RANK() OVER (ORDER BY "population_reachable" DESC) AS "rank"
8FROM "@esifunds.bp5k_ynxy.table_1"
9WHERE "time_opti" <= 120
10GROUP BY "country", "city", "population_city"
11ORDER BY "population_reachable" DESC
12LIMIT 10