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