kaibladeTop 10 Organizations with the Most Activities
    Updated 2023-01-25
    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


    Run a query to Download Data