kaiblade Weekly Merged Commits Based on Repo
    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 DATE_TRUNC('week', closedat) AS "Weeks", COUNT(ID) AS "Number of Merge Commits",
    repo
    FROM raw_data
    WHERE commit_id IS NOT NULL
    GROUP BY "Weeks", repo
    ORDER BY "Number of Merge Commits" DESC



    Run a query to Download Data