ilhamije/jawaban_DE_SQL_1.sql

Created April 26, 2020 03:14

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

Download ZIP

JDS-ilham-DE-SQL-1

Raw

jawaban_DE_SQL_1.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