Skip to content

Instantly share code, notes, and snippets.

@ashumeow

ashumeow/query.sql

Forked from igrigorik/query.sql
Last active August 29, 2015 14:14
Show Gist options
  • Save ashumeow/43d94def3d6bfa4f93db to your computer and use it in GitHub Desktop.
Save ashumeow/43d94def3d6bfa4f93db to your computer and use it in GitHub Desktop.
Download ZIP
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