Skip to content

Instantly share code, notes, and snippets.

@grgaortiz

grgaortiz/EmployeeMajorDistribution.sql

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