most_followed_github_users_from_nepal.sql

  --
  -- Most followed users as of March 2017
  -- If the user has been unfollowed it still counts as a follow
  --
  -- https://bigquery.cloud.google.com/savedquery/39178653524:3c9bf26cf2054e50a53d325f869e129a
  --
SELECT
  u.login AS login,
  u.location AS location,
  count(f.follower_id) AS num_followers
FROM
  [ghtorrent-bq.ght_2017_04_01.users] u
JOIN
  [ghtorrent-bq.ght_2017_04_01.followers] f
ON
  u.id = f.user_id
WHERE
  u.country_code = 'np'
GROUP BY
  login,
  location
ORDER BY
  num_followers DESC;