Sample query for github dataset in big-query

github-mining.sql

SELECT
  cont.sample_repo_name,
  repo.watch_count
FROM
  [bigquery-public-data:github_repos.sample_contents] as cont
JOIN [bigquery-public-data:github_repos.sample_repos] as repo
  ON cont.sample_repo_name = repo.repo_name  
WHERE
  cont.content CONTAINS 'findbugs-maven-plugin</artifactId>'
  AND cont.sample_path LIKE 'pom.xml'
ORDER BY repo.watch_count DESC
LIMIT
  40;