Skip to content

Instantly share code, notes, and snippets.

@vdubyna

vdubyna/requests-per-hour.sql

Created March 20, 2014 19:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vdubyna/9671521 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vdubyna/9671521 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
requests-per-hour.sql
select count(*), HOUR(lu.visit_time) from log_url_info as ui JOIN log_url as lu on lu.url_id=ui.url_id JOIN log_visitor_info as vi on lu.visitor_id=vi.visitor_id where date(lu.visit_time) = '2014-03-19' GROUP BY HOUR(lu.visit_time);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment