bartubozkurt/having.sql

Created June 13, 2021 09:26

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

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

Download ZIP

lists the number of customers in each country. Only include countries with more than 5 customers

Raw

	SELECT COUNT(CustomerID), Country
	FROM Customers
	GROUP BY Country
	HAVING COUNT(CustomerID) > 5 ;

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