Baselight
WITH combined_data AS (
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.united_states_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.japan_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.germany_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.russia_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.united_kingdom_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.china_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.india_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.france_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.canada_timeseries_stats
    UNION ALL
    SELECT place_name, date, variable, value
    FROM @datacommons.countries.italy_timeseries_stats
)

SELECT
    place_name,
    value as max_temp_2040
FROM combined_data
WHERE combined_data.variable = 'MaxTemp_Daily_Hist_95PctProb_Greater_Atleast1DayADecade_CMIP6_Ensemble_SSP585'
      and date = 2040
order by value desc


place_namemax_temp_2040
United States52
India51
China49
Russia46
Canada44
France42
Japan41
Italy41
Germany40
United Kingdom32

Share link

Anyone who has the link will be able to view this.