Skip to content

Instantly share code, notes, and snippets.

@b0noI

b0noI/query_bq.sql

Created September 13, 2018 00:49
Show Gist options
  • Save b0noI/ba57a73b36f8f54748020bb4472607d3 to your computer and use it in GitHub Desktop.
Save b0noI/ba57a73b36f8f54748020bb4472607d3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_bq.sql
%%bigquery
SELECT
source_year AS year,
COUNT(is_male) AS birth_count
FROM `bigquery-public-data.samples.natality`
GROUP BY year
ORDER BY year DESC
LIMIT 15
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment