WITH raw_data AS
(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 org, COUNT(ID) AS "Number of Activities (org)"
FROM raw_data
GROUP BY org
ORDER BY "Number of Activities (org)" DESC
LIMIT 10