arizalsandi/session.sql

Last active June 17, 2021 04:06

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/arizalsandi/e609deebf84e7f228e244ef649bd0d13.js"></script>
Save arizalsandi/e609deebf84e7f228e244ef649bd0d13 to your computer and use it in GitHub Desktop.

Download ZIP

session

Raw

session.sql

	SELECT userId, avg(duration)
	FROM sessions
	GROUP BY userId
	HAVING COUNT (userId) > 1;

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