Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #StandardSQL
- SELECT state, year, COUNT(*) AS count_babies
- FROM `bigquery-public-data.samples.natality`
- WHERE year >= 1980 and year < 1990
- GROUP BY state, year
- ORDER BY 3 desc
- LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement