SELECT * FROM
(SELECT 'desktop' type,
NTH(50, quantiles(renderStart,101)) median,
NTH(75, quantiles(renderStart,101)) seventy_fifth,
NTH(90, quantiles(renderStart,101)) ninetieth
FROM [httparchive:runs.latest_pages]),
(SELECT 'mobile' type,
NTH(50, quantiles(renderStart,101)) median,
NTH(75, quantiles(renderStart,101)) seventy_fifth,
NTH(90, quantiles(renderStart,101)) ninetieth
FROM [httparchive:runs.latest_pages_mobile])
Note: prior to July 1st 2013, mobile renders were performed with a Wi-Fi profile. Newer runs use 3G profile, as defined in WebPageTest.