(Select *, SPLIT(url, '/') AS split_url, split_url[ARRAY_SIZE(split_url)-2] AS action_type, mergecommit:oid AS commit_id

FROM near.beta.github_activity)

SELECT DATE_TRUNC('week', closedat) AS "Weeks", COUNT(ID) AS "Number of Merge Commits",

org

FROM raw_data

WHERE commit_id IS NOT NULL

GROUP BY "Weeks", org