Skip to content

Instantly share code, notes, and snippets.

@grgaortiz

grgaortiz/GraphicDesignAgencyDistribution.sql

Created October 30, 2015 17:47
Show Gist options
  • Save grgaortiz/7d7423e0bf390d8cfcdf to your computer and use it in GitHub Desktop.
Save grgaortiz/7d7423e0bf390d8cfcdf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
GraphicDesignAgencyDistribution.sql
SELECT current AS Agency,
(count(current)/37*100) AS Percent
FROM UtahAgencyEmployees
WHERE latest_education_major = 'Graphic Design'
GROUP BY current
ORDER BY Percent DESC
LIMIT 20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment