1SELECT "city", ROW_NUMBER() OVER (ORDER BY jan)
2FROM @kaggle.prasertk_sunshine_duration_by_city.sunshine_hours_by_city| city | row_number() OVER (ORDER BY jan) |
|---|---|
| Dikson | 1 |
| Tromsø | 2 |
| Tórshavn | 3 |
| Yakutsk | 4 |
| Bergen | 5 |
| Reykjavik | 6 |
| Tallinn | 7 |
| Riga | 8 |
| Kyiv | 9 |
| Vilnius | 10 |
| Iqaluit | 11 |
| Minsk | 12 |
| Vilsandi | 13 |
| Moscow | 14 |
| Helsinki | 15 |
| Oslo | 16 |
| Stockholm | 17 |
| Rønne | 18 |
| Luxembourg City | 19 |
| Warsaw | 20 |
| Whitehorse | 21 |
| Gothenburg | 22 |
| Berlin | 23 |
| Chongqing | 24 |
| Zurich | 25 |
| Saint-Pierre | 26 |
| Prague | 27 |
| Frankfurt | 28 |
| Aarhus | 29 |
| Edinburgh | 30 |
| Copenhagen | 31 |
| Sarajevo | 32 |
| Brussels | 33 |
| Zagreb | 34 |
| Dublin | 35 |
| Milan | 36 |
| Vancouver | 37 |
| Geneva | 38 |
| Budapest | 39 |
| London | 40 |
| Nome | 41 |
| Paris | 42 |
| Amsterdam | 43 |
| Kanazawa | 44 |
| Niš | 45 |
| Bratislava | 46 |
| Vienna | 47 |
| Omsk | 48 |
| Seattle | 49 |
| Bucharest | 50 |
| Ljubljana | 51 |
| Istanbul | 52 |
| Belgrade | 53 |
| Lyon | 54 |
| Hanoi | 55 |
| Chișinău | 56 |
| Ankara | 57 |
| Churchill | 58 |
| Taipei | 59 |
| Anchorage | 60 |
| Portland (OR) | 61 |
| Toronto | 62 |
| Skopje | 63 |
| Sofia | 64 |
| Baku | 65 |
| Sapporo | 66 |
| Yerevan | 67 |
| Irkutsk | 68 |
| Sion | 69 |
| Pittsburgh | 70 |
| Cayenne | 71 |
| Sochi | 72 |
| Tbilisi | 73 |
| Edmonton | 74 |
| Montreal | 75 |
| Cleveland | 76 |
| Fuzhou | 77 |
| Ürümqi | 78 |
| Wuhan | 79 |
| Guayaquil | 80 |
| Astana | 81 |
| Petropavlovsk-Kamchatsky | 82 |
| Boise | 83 |
| Columbus | 84 |
| Manaus | 85 |
| Shanghai | 86 |
| Winnipeg | 87 |
| Naples | 88 |
| Tashkent | 89 |
| Almaty | 90 |
| Guangzhou | 91 |
| Calgary | 92 |
| Detroit | 93 |
| Rome | 94 |
| Podgorica | 95 |
| Ningbo | 96 |
| Tirana | 97 |
| Kinshasa | 98 |
| Porto | 99 |
| Lugano | 100 |
| Nanjing | 101 |
| Tabriz | 102 |
| Macau | 103 |
| Salt Lake City | 104 |
| Lubumbashi | 105 |
| Medan | 106 |
| Athens | 107 |
| Belém | 108 |
| Indianapolis | 109 |
| Split | 110 |
| Xiamen | 111 |
| Chicago | 112 |
| Tehran | 113 |
| Da Nang | 114 |
| São Paulo | 115 |
| Nashville | 116 |
| Milwaukee | 117 |
| Louisville | 118 |
| Fresno | 119 |
| Monterrey | 120 |
| Hong Kong | 121 |
| Lisbon | 122 |
| Houston | 123 |
| Washington,D.C. | 124 |
| Sacramento | 125 |
| Mzuzu | 126 |
| Tunis | 127 |
| Madrid | 128 |
| Sendai | 129 |
| Mashhad | 130 |
| Malabo | 131 |
| Algiers | 132 |
| Monaco | 133 |
| Marseille | 134 |
| Cagliari | 135 |
| Port-Gentil | 136 |
| Brasília | 137 |
| Ndola | 138 |
| Dolisie | 139 |
| New Orleans | 140 |
| Makassar | 141 |
| Baltimore | 142 |
| Philadelphia | 143 |
| Bogotá | 144 |
| Minneapolis | 145 |
| Pointe-Noire | 146 |
| Barcelona | 147 |
| San Antonio | 148 |
| Seoul | 149 |
| Curitiba | 150 |
| St. Louis | 151 |
| New York City | 152 |
| Boston | 153 |
| Austin | 154 |
| Raleigh | 155 |
| Atlanta | 156 |
| Salta | 157 |
| Lagos | 158 |
| Memphis | 159 |
| Bujumbura | 160 |
| Omaha | 161 |
| Brazzaville | 162 |
| Villahermosa | 163 |
| Valletta | 164 |
| Tianjin | 165 |
| Nagoya | 166 |
| La Ceiba | 167 |
| Valencia | 168 |
| Virginia Beach | 169 |
| Faro | 170 |
| Singapore | 171 |
| Richmond (VA) | 172 |
| Denpasar | 173 |
| Charlotte | 174 |
| Kaohsiung | 175 |
| Libreville | 176 |
| Medellín | 177 |
| Tulsa | 178 |
| Belo Horizonte | 179 |
| Taichung | 180 |
| Darwin | 181 |
| Karonga | 182 |
| Manila | 183 |
| Lusaka | 184 |
| Yaoundé | 185 |
| Kabul | 186 |
| Vladivostok | 187 |
| Ulaanbaatar | 188 |
| Lima | 189 |
| Dunedin | 190 |
| Benghazi | 191 |
| Rabat | 192 |
| Ushuaia | 193 |
| Port Moresby | 194 |
| La Paz | 195 |
| Nicosia | 196 |
| Hat Yai | 197 |
| Cali | 198 |
| Gagnoa | 199 |
| Seville | 200 |
| Dallas | 201 |
| Kansas City | 202 |
| Douala | 203 |
| Pyongyang | 204 |
| Durban | 205 |
| Cádiz | 206 |
| Tokyo | 207 |
| San Francisco | 208 |
| Qingdao | 209 |
| Honiara | 210 |
| Kumasi | 211 |
| Jakarta | 212 |
| Antsiranana | 213 |
| Jacksonville | 214 |
| Wichita | 215 |
| Fianarantsoa | 216 |
| Suva | 217 |
| Baghdad | 218 |
| Tel Aviv | 219 |
| Beijing | 220 |
| Rio de Janeiro | 221 |
| Quito | 222 |
| Stanley | 223 |
| Blantyre | 224 |
| Busan | 225 |
| Tampa | 226 |
| La Paz | 227 |
| OklahomaCity | 228 |
| Georgetown | 229 |
| Bata | 230 |
| Kolkata | 231 |
| Isfahan | 232 |
| Tripoli | 233 |
| Mahajanga | 234 |
| Antananarivo | 235 |
| Riyadh | 236 |
| Honolulu | 237 |
| Cotonou | 238 |
| Livingstone | 239 |
| Port Sudan | 240 |
| Delhi | 241 |
| Denver | 242 |
| Tabora | 243 |
| Bangui | 244 |
| Alexandria | 245 |
| Accra | 246 |
| Harare | 247 |
| Lomé | 248 |
| Lahore | 249 |
| Luanda | 250 |
| Miami | 251 |
| Sydney | 252 |
| Bandar Abbas | 253 |
| Marrakech | 254 |
| Gabes | 255 |
| Fortaleza | 256 |
| Conakry | 257 |
| Abidjan | 258 |
| Arequipa | 259 |
| Christchurch | 260 |
| Toamasina | 261 |
| Los Angeles | 262 |
| Nakhon Ratchasima | 263 |
| Porto Alegre | 264 |
| Auckland | 265 |
| Panama City | 266 |
| Quetta | 267 |
| Cairo | 268 |
| Caracas | 269 |
| Chennai | 270 |
| Recife | 271 |
| Entebbe | 272 |
| Albuquerque | 273 |
| Makurdi | 274 |
| San Juan | 275 |
| Kampala | 276 |
| San Diego | 277 |
| Mexico City | 278 |
| Wellington | 279 |
| Dodoma | 280 |
| Bouaké | 281 |
| Odienné | 282 |
| Bulawayo | 283 |
| Maun | 284 |
| Ho Chi Minh City | 285 |
| Las Vegas | 286 |
| Salvador | 287 |
| Bissau | 288 |
| Maputo | 289 |
| Ciudad Bolivar | 290 |
| Johannesburg | 291 |
| Lhasa | 292 |
| Dar-es-Salaam | 293 |
| Zanzibar | 294 |
| La Plata | 295 |
| Garissa | 296 |
| Ouarzazate | 297 |
| Dakar | 298 |
| Djibouti City | 299 |
| Dubai | 300 |
| El Paso | 301 |
| Da Lat | 302 |
| Phoenix | 303 |
| Córdoba | 304 |
| Hobart | 305 |
| Valdivia | 306 |
| Tucson | 307 |
| Parakou | 308 |
| Pretoria | 309 |
| Kankan | 310 |
| Bangalore | 311 |
| Brisbane | 312 |
| Managua | 313 |
| Timbuktu | 314 |
| Tamale | 315 |
| Hurghada | 316 |
| Melbourne | 317 |
| Abha | 318 |
| Nouakchott | 319 |
| Thiès | 320 |
| Mogadishu | 321 |
| Yuma | 322 |
| Muscat | 323 |
| Mumbai | 324 |
| Addis Abeba | 325 |
| Mombasa | 326 |
| Karachi | 327 |
| Nouadhibou | 328 |
| Bangkok | 329 |
| Chiang Mai | 330 |
| Garoua | 331 |
| Kano | 332 |
| Asunción | 333 |
| Bamako | 334 |
| Buenos Aires | 335 |
| Dhaka | 336 |
| Kandi | 337 |
| Marsa Alam | 338 |
| Banjul | 339 |
| Ferké | 340 |
| Sokoto | 341 |
| Gaborone | 342 |
| Barranquilla | 343 |
| Mango | 344 |
| N'Gaoundéré | 345 |
| Ouagadougou | 346 |
| Windhoek | 347 |
| Nairobi | 348 |
| Juba | 349 |
| Birao | 350 |
| Buloburde | 351 |
| Ouahigouya | 352 |
| Ségou | 353 |
| Mekelle | 354 |
| Canberra | 355 |
| Dakhla Oasis | 356 |
| Montevideo | 357 |
| Ghanzi | 358 |
| Bloemfontein | 359 |
| Tamanrasset | 360 |
| Mendoza | 361 |
| N'Djamena | 362 |
| Niamey | 363 |
| Maracaibo | 364 |
| Wau | 365 |
| San Salvador | 366 |
| Asmara | 367 |
| Toliara | 368 |
| Alice Springs | 369 |
| Jos | 370 |
| Abéché | 371 |
| Lodwar | 372 |
| Antofagasta | 373 |
| Adelaide | 374 |
| Cape Town | 375 |
| Concepción | 376 |
| Khartoum | 377 |
| Upington | 378 |
| Keetmanshoop | 379 |
| Calama | 380 |
| Perth | 381 |
| Santiago | 382 |