4 ms·
/* What is the range of elevations where tornadoes happen? */ SELECT elev, COUNT(*) AS count FROM `fh-bigquery.weather_gsod.all`
by perl4ever 5y ago
/*
What is the range of elevations where tornadoes happen?
*/
SELECT
elev,
COUNT(*) AS count
FROM
`fh-bigquery.weather_gsod.all`
WHERE
tornado_funnel_cloud = 'T'
GROUP BY
elev
ORDER BY
count DESC