Skip to content

Instantly share code, notes, and snippets.

@avivl

avivl/submission_by_time.sql

Last active December 27, 2017 11:37
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 avivl/8e7e828509407676ba129c1f376a06a6 to your computer and use it in GitHub Desktop.
Save avivl/8e7e828509407676ba129c1f376a06a6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
submission_by_time.sql
SELECT HOUR(sent_time) hour_submission,
COUNT(*) as num_submissions
FROM [[telegrass_reviews.reviews]
GROUP BY hour_submission
ORDER by hour_submission
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment