FCP

ext_comp.sql

SELECT
  origin,
  effective_connection_type.name AS ect,
  MULTIPLY(ROUND(SUM( first_contentful_paint.histogram.bin.density), 4), 100) AS density
FROM
  [chrome-ux-report:all.201711]
WHERE
  origin IN ('https://m.ebay.com', 'https://www.amazon.com') AND
  form_factor.name = "phone"
GROUP BY
  origin,
  ect
ORDER BY
  origin,
  ect

fcp_comp.sql

SELECT
  origin,
  MULTIPLY(ROUND(SUM(IF(first_contentful_paint.histogram.bin.start < 1000, first_contentful_paint.histogram.bin.density , 0)) / SUM( first_contentful_paint.histogram.bin.density ), 4), 100) AS fast_AboveTheFold,
  MULTIPLY(ROUND(SUM(IF(first_contentful_paint.histogram.bin.start >= 1000 AND first_contentful_paint.histogram.bin.start < 3000, first_contentful_paint.histogram.bin.density, 0)) / SUM(first_contentful_paint.histogram.bin.density), 4), 100) AS average_AboveTheFold,
  MULTIPLY(ROUND(SUM(IF(first_contentful_paint.histogram.bin.start >= 3000, first_contentful_paint.histogram.bin.density, 0)) / SUM(first_contentful_paint.histogram.bin.density), 4), 100) AS slow_AboveTheFold  
FROM
  [chrome-ux-report:all.201903]
WHERE
  origin IN ('https://www.ebay.com', 'https://www.amazon.com') AND
  form_factor.name = "desktop"
GROUP BY
  origin