Skip to content

Instantly share code, notes, and snippets.

@grgaortiz

grgaortiz/EmployeeSchoolDistribution.sql

Created October 30, 2015 17:53
Show Gist options
  • Save grgaortiz/cb22809c16afdfb342fa to your computer and use it in GitHub Desktop.
Save grgaortiz/cb22809c16afdfb342fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
EmployeeSchoolDistribution.sql
SELECT education AS School,
count(education) AS Employees
FROM UtahAgencyEmployees
WHERE education != ''
GROUP BY education
ORDER BY Employees DESC
LIMIT 20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment