Skip to content

Instantly share code, notes, and snippets.

@ricalo

ricalo/todofix.sql

Created August 17, 2016 04:57
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 ricalo/47996abbd0192433b0a4631541a945fa to your computer and use it in GitHub Desktop.
Save ricalo/47996abbd0192433b0a4631541a945fa to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery - Get all todo: fix comments
Raw
todofix.sql
SELECT
SUM(copies)
FROM
[bigquery-public-data:github_repos.contents]
WHERE
NOT binary
AND lower(content) CONTAINS 'todo: fix'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment