Skip to content

Instantly share code, notes, and snippets.

@JanPaulEttles

JanPaulEttles/scope.sql

Created March 12, 2012 11:54
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save JanPaulEttles/2021381 to your computer and use it in GitHub Desktop.
Download ZIP
scope
Raw
scope.sql
SELECT DATE(date), count(*)
FROM collection
WHERE stuffDate > from AND stuffDate < to
GROUP BY DATE(date);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment