Abidzar16/DE_SQL_1.sql

Last active August 14, 2020 04:47

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

Download ZIP

DE_SQL soal nomor 1

Raw

DE_SQL_1.sql

	SELECT DISTINCT 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