World average temperature per country
Sign In
- Project InformationProject Nameweather githubDataframe Nameresults-20170601-182320Created ByFelipe HoffaCreated DateUpdated DateDesktop Version1.7.0ScheduleScheduling is not supported because:
- Refreshing Local File Data Source is not supported.
Last Refresh Log (Schedule)Start TimeFinish TimeTime ElapsedProcessed Data SizeProcessed # of Rows
The preview data is not shown because the data was published by an older version of Exploratory Desktop.
Updated the column descriptions successfully.
Failed to connect to the server. Please contactsupport@exploratory.io.
Description
standardSQL
SELECT * FROM (
SELECT , ROUND(AVG(temp) OVER(PARTITION BY country), 2) country_avg
FROM (
SELECT c.country, stn, ROUND((AVG(temp)-32)5/9, 2) temp
, COUNT(stn) OVER(PARTITION BY c.country) country_stations
, ANY_VALUE(continent) continent
FROM bigquery-public-data.noaa_gsod.gsod2016 a
JOIN bigquery-public-data.noaa_gsod.stations b
ON a.stn=b.usaf AND a.wban=b.wban
JOIN gdelt-bq.extra.countryinfo2 c
ON b.country=c.fips
GROUP BY 1, 2
)
WHERE country_stations>10
OR country='Singapore'
)
ORDER BY country_avg
Styling with Markdown is supported
