Skip to content

Instantly share code, notes, and snippets.

@tswast

tswast/highest-high.sql

Created February 15, 2017 21:26
Show Gist options
  • Save tswast/0b6e5af5175f39202e2576cf7c1da515 to your computer and use it in GitHub Desktop.
Save tswast/0b6e5af5175f39202e2576cf7c1da515 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
highest-high.sql
#standardSQL
SELECT
MAX(max) AS highest_high,
stn,
wban
FROM `bigquery-public-data.noaa_gsod.gsod*`
WHERE max != 9999.9
GROUP BY stn, wban
ORDER BY highest_high DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment