grgaortiz/EmployeeSkillDistribution.sql

Created October 30, 2015 17:50

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/grgaortiz/78c85e05c6500d41bac0.js"></script>
Save grgaortiz/78c85e05c6500d41bac0 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

EmployeeSkillDistribution.sql

	SELECT skill,
	count(*) as count
	FROM EmployeeSkills
	WHERE skill != ''
	GROUP BY skill
	ORDER BY Count DESC
	Limit 20

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment