native-vs-global-amazon-china.sql

  WITH query1 AS (
  SELECT
    'china' AS country_code,
    origin,
    ROUND(SUM(IF(fcp.start <=1000, fcp.density,0)) / SUM(fcp.density),5) AS SEB_native
  FROM
    `chrome-ux-report.country_cn.201712`,
    UNNEST(first_contentful_paint.histogram.bin) AS fcp
  WHERE
    origin = 'https://www.amazon.cn'
  GROUP BY
    origin),
  query2 AS (
  SELECT
    origin,
    ROUND(SUM(IF(fcp.start <=1000, fcp.density,0)) / SUM(fcp.density),5) AS SEB_global
  FROM
    `chrome-ux-report.country_cn.201712`,
    UNNEST(first_contentful_paint.histogram.bin) AS fcp
  WHERE
    origin = 'https://www.amazon.com'
  GROUP BY
    origin )
SELECT
  country_code,
  SEB_native,
  SEB_global
FROM
  query1,
  query2