Skip to content

Instantly share code, notes, and snippets.

@ivanpk

ivanpk/distinct.sql Secret

Created February 4, 2020 23:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ivanpk/33d2d63e9c34a827872d2f1fc25c0b3c to your computer and use it in GitHub Desktop.
Save ivanpk/33d2d63e9c34a827872d2f1fc25c0b3c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
distinct.sql
SELECT
DATE(created_at) AS day,
COUNT(DISTINCT user_id) AS distinct_users
FROM
`example-project.ivan.article_example_dataset`
GROUP BY
1
ORDER BY
1 DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment