Skip to content

Instantly share code, notes, and snippets.

@henvic
Last active February 21, 2019 21:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save henvic/96476c4271957617033d0d8844cd5068 to your computer and use it in GitHub Desktop.
Save henvic/96476c4271957617033d0d8844cd5068 to your computer and use it in GitHub Desktop.
Go repositories licenses on GitHub (February, 2019)
-- https://bigquery.cloud.google.com/savedquery/921239845235:55c08a36753340b398c10a8130c2e68f
SELECT
COUNT(rlic.license) AS total,
rlic.license
FROM
[bigquery-public-data:github_repos.licenses] AS rlic
LEFT OUTER JOIN
[bigquery-public-data:github_repos.languages] AS rlang
ON
rlic.repo_name = rlang.repo_name
WHERE
language.name == "Go"
GROUP BY
rlic.license
ORDER BY
total DESC
-- https://bigquery.cloud.google.com/savedquery/921239845235:fe5160b5d98f493daf65cd67d5ea0253
SELECT
COUNT(rlic.license) AS total,
rlic.license
FROM
[bigquery-public-data:github_repos.licenses] AS rlic
GROUP BY
rlic.license
ORDER BY
total DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment