1WITH combined_data AS (
2    SELECT place_name, date, variable, value
3    FROM @datacommons.countries.united_states_country_usa
4    UNION ALL
5    SELECT place_name, date, variable, value
6    FROM @datacommons.countries.japan_country_jpn
7    UNION ALL
8    SELECT place_name, date, variable, value
9    FROM @datacommons.countries.germany_country_deu
10    UNION ALL
11    SELECT place_name, date, variable, value
12    FROM @datacommons.countries.russia_country_rus
13    UNION ALL
14    SELECT place_name, date, variable, value
15    FROM @datacommons.countries.united_kingdom_country_gbr
16    UNION ALL
17    SELECT place_name, date, variable, value
18    FROM @datacommons.countries.china_country_chn
19    UNION ALL
20    SELECT place_name, date, variable, value
21    FROM @datacommons.countries.india_country_ind
22    UNION ALL
23    SELECT place_name, date, variable, value
24    FROM @datacommons.countries.france_country_fra
25    UNION ALL
26    SELECT place_name, date, variable, value
27    FROM @datacommons.countries.canada_country_can
28    UNION ALL
29    SELECT place_name, date, variable, value
30    FROM @datacommons.countries.italy_country_ita
31)
32
33SELECT
34    place_name,
35    value as max_temp_2040
36FROM combined_data
37WHERE combined_data.variable = 'MaxTemp_Daily_Hist_95PctProb_Greater_Atleast1DayADecade_CMIP6_Ensemble_SSP585'
38      and date = 2040
39order by value desc
40
41
42