| SELECT task, (count(distinct projectID) / 202808 * 100) as percent | |
| FROM [scripts] | |
| WHERE taskName = 'test' | |
| GROUP BY task | |
| ORDER BY percent DESC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment