number_of_commits_for_a_user.sql

  --
  -- Most unique commits from Jan 2016 to March 2017 for `mesaugat`
  -- Change `mesaugat` to any other username to get number of commits for that username
  --
  -- https://bigquery.cloud.google.com/savedquery/39178653524:9a10947dbf8f429da6dd5193592d2d61
  --
SELECT
  u.login AS login,
  u.location AS location,
  u.country_code AS country_code,
  COUNT(c.id) AS num_commits
FROM
  [ghtorrent-bq.ght_2017_04_01.commits] c
JOIN (
  SELECT
    login,
    location,
    country_code,
    id
  FROM
    [ghtorrent-bq.ght_2017_04_01.users]
  WHERE
    login = 'mesaugat' ) u
ON
  c.author_id = u.id,
WHERE
  DATE(created_at) BETWEEN DATE('2016-01-01')
  AND DATE('2017-04-01')
GROUP BY
  login,
  location,
  country_code
ORDER BY
  num_commits DESC;