leemour/count_by_month.sql

Created May 15, 2018 14:26

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/leemour/8cdf06385abe4ee911ea1d0da778d4fd.js"></script>
Save leemour/8cdf06385abe4ee911ea1d0da778d4fd to your computer and use it in GitHub Desktop.

Download ZIP

Group and count by month SQL query

Raw

count_by_month.sql

	SELECT count(*), DATE_TRUNC( 'month', created_at ) created_date
	FROM businesses
	GROUP BY created_date

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment