title: How to query GHTorrent's (SQL-like language) for country/city/users number/repositories number?
body: <p>I've read a lot of documentation on GitHub data retrieval and viewed Github user commits/pushes data via BiGQuery but failed to find city, country fields and failed to find any description on such queries. Though there is information that such queries are theoretically possible - <a href="https://gist.github.com/kelewis/4bc942f9433c41b1ddb6/" rel="nofollow noreferrer">https://gist.github.com/kelewis/4bc942f9433c41b1ddb6/</a>. But this requires Azure lake (??) . Does anyone know how to query Github data via /My_SQL/Postgres/BigQuery/, or any python (Jupiter) SQL like functions - for example pandas DataFrames with &quot;country&quot; and &quot;city&quot; fields?</p>
  <p>Smth like this example
  .......................</p>
  <p>SELECT
  city, country,
  SUM(number) AS total
  FROM
  <code>ghtorrent-bq.ght.commits</code>
  GROUP BY
  country, region
  ORDER BY
  total DESC
  LIMIT
  10000
  .......
  Thanx!</p>