Skip to content

Instantly share code, notes, and snippets.

@Everettss

Everettss/build-tasks.sql

Created September 18, 2017 15:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Everettss/13a5d2dc4f4539b5aa4043f0d955f879 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Everettss/13a5d2dc4f4539b5aa4043f0d955f879 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Everettss created this gist Sep 18, 2017.
    5 changes: 5 additions & 0 deletions build-tasks.sql
    View file
    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