Skip to content

Instantly share code, notes, and snippets.

@guerbai

guerbai/sql_with_example.sql

Created June 2, 2019 05:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save guerbai/e560b8adaf98ba416657af83b859e6c7 to your computer and use it in GitHub Desktop.
Save guerbai/e560b8adaf98ba416657af83b859e6c7 to your computer and use it in GitHub Desktop.
Download ZIP
sql with example #BigQuery
Raw
sql_with_example.sql
WITH time AS
(
SELECT DATE(block_timestamp) AS trans_date
FROM `bigquery-public-data.crypto_bitcoin.transactions`
)
SELECT COUNT(1) AS transactions,
trans_date
FROM time
GROUP BY trans_date
ORDER BY trans_date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment