Skip to content

Instantly share code, notes, and snippets.

@shibacow

shibacow/test.sql

Created January 19, 2016 18:27
Show Gist options
  • Save shibacow/8d0ce473868a12c1a651 to your computer and use it in GitHub Desktop.
Save shibacow/8d0ce473868a12c1a651 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.sql
select count_distinct(user_id) as count,
date_format(time,'%Y-%m-%d') as date,
world
from [table20150101-201531]
group by date,world
order by date,world;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment