Skip to content

Instantly share code, notes, and snippets.

@urish

urish/bigquery-typescript-sizes.sql Secret

Created May 27, 2018 23:10
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 urish/d2d2ca07e7e20fcef3f3231efa88424c to your computer and use it in GitHub Desktop.
Save urish/d2d2ca07e7e20fcef3f3231efa88424c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery-typescript-sizes.sql
SELECT
MAX(size) AS size,
SUM(COUNT(*)) OVER (ORDER BY MAX(size))
FROM
typescript.tscontents
GROUP BY
CEIL(LOG(size, 2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment