bq099.sql

SELECT
  name, 
  value/10 AS min_temperature,
  latitude,
  longitude
FROM
  `bigquery-public-data.ghcn_d.ghcnd_stations` AS stn
JOIN
  `bigquery-public-data.ghcn_d.ghcnd_2016` AS wx
ON
  wx.id = stn.id
WHERE
  wx.element = 'TMIN'
  AND wx.qflag IS NULL
  AND STRING(wx.date) = '2016-08-15'