dhalperi

WITH since_incubation AS (
   SELECT * FROM `githubarchive.day.201*`
   WHERE _TABLE_SUFFIX > '60131' -- after 2016-01-31 since Beam started incubating on 2016-02-01
),
pull_requests AS (
  SELECT
    -- map a podling to its final name
    replace(e.repo.name, "incubator-", "") AS repo,
    COUNT(*) AS pr_count
  FROM since_incubation AS e