Skip to content

Instantly share code, notes, and snippets.

@gustavopinto
Created July 11, 2016 18:35
Show Gist options
  • Save gustavopinto/2d287a92eb4c9f7180043a3f3648215e to your computer and use it in GitHub Desktop.
Save gustavopinto/2d287a92eb4c9f7180043a3f3648215e to your computer and use it in GitHub Desktop.
Top10 most popular OSS licenses
SELECT count(repo_name) as total, license
FROM [bigquery-public-data:github_repos.licenses]
Group By license
order by total desc
limit 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment