most_unique_commits_per_user_from_nepal.sql

  --
  -- Most unique commits per user from Jan 2016 to March 2017
  --
  -- https://bigquery.cloud.google.com/savedquery/39178653524:e4b670a18035460792b0554983dde6ad
  --
SELECT
  u.login AS login,
  u.location AS location,
  COUNT(c.id) AS num_commits
FROM
  [ghtorrent-bq.ght_2017_04_01.commits] c
JOIN (
  SELECT
    login,
    location,
    id
  FROM
    [ghtorrent-bq.ght_2017_04_01.users]
  WHERE
    country_code = 'np') 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
ORDER BY
  num_commits DESC;