Skip to content

Instantly share code, notes, and snippets.

@Everettss
Created September 18, 2017 15:04
Show Gist options
  • Select an option

  • Save Everettss/13a5d2dc4f4539b5aa4043f0d955f879 to your computer and use it in GitHub Desktop.

Select an option

Save Everettss/13a5d2dc4f4539b5aa4043f0d955f879 to your computer and use it in GitHub Desktop.

Revisions

  1. Everettss created this gist Sep 18, 2017.
    5 changes: 5 additions & 0 deletions build-tasks.sql
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    SELECT task, (count(distinct projectID) / 65794 * 100) as percent
    FROM [scripts]
    WHERE taskName = 'build'
    GROUP BY task
    ORDER BY percent DESC