bartubozkurt/avg.sql

Created June 11, 2021 18:19

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

Select an option

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

Download ZIP

Find out the average rating for cities in respective countries if the average is above 3.0

Raw

avg.sql

	SELECT country_id , AVG(rating)
	FROM city
	GROUP BY country_id
	HAVING AVG(rating) > 3.0;

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