Skip to content

Instantly share code, notes, and snippets.

@igrigorik

igrigorik/query.sql

Created January 23, 2015 19:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save igrigorik/3ec49bc83ba9e1876d34 to your computer and use it in GitHub Desktop.
Save igrigorik/3ec49bc83ba9e1876d34 to your computer and use it in GitHub Desktop.
Download ZIP
CSS size
Raw
query.sql
SELECT * FROM
(SELECT 'desktop' type,
NTH(50, quantiles(bytesCSS)) median,
NTH(75, quantiles(bytesCSS)) seventy_fifth,
NTH(90, quantiles(bytesCSS)) ninetieth
FROM [httparchive:runs.latest_pages]),
(SELECT 'mobile' type,
NTH(50, quantiles(bytesCSS)) median,
NTH(75, quantiles(bytesCSS)) seventy_fifth,
NTH(90, quantiles(bytesCSS)) ninetieth
FROM [httparchive:runs.latest_pages_mobile])
Raw
result.csv
type median seventy_fifth ninetieth
desktop 29070 65255 138816
mobile 21458 51318 115983
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment