Skip to content

Instantly share code, notes, and snippets.

@ilhamije

ilhamije/jawaban_DE_SQL_1.sql

Created April 26, 2020 03:14
Show Gist options
  • Save ilhamije/da9c7903bca50753b995d4b53f6c7d5d to your computer and use it in GitHub Desktop.
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