SELECT 
  "country_larger_city" AS "country", 
  "larger_city" AS "city", 
  "pop_larger_city" AS "population_city", 
  SUM("pop_smaller_city") AS "population_reachable",
  ROUND(SUM("pop_smaller_city") / "pop_larger_city",2) AS "population_ratio",
  RANK() OVER (ORDER BY "population_reachable" DESC) AS "rank"
FROM "@esifunds.bp5k_ynxy.table_1"
WHERE "time_opti" <= 120
GROUP BY "country", "city", "population_city"
ORDER BY "population_reachable" DESC
LIMIT 10