Skip to content

Instantly share code, notes, and snippets.

@shibacow

shibacow/test.sql

Created October 29, 2017 00:21
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 shibacow/1f44bbd75fd9e885573d15260e95e6d5 to your computer and use it in GitHub Desktop.
Save shibacow/1f44bbd75fd9e885573d15260e95e6d5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.sql
select strftime_utc_usec(upload_time,"%Y-%m") as umonth,
count(1)
FROM [nicodata.video]
GROUP BY umonth
order by umonth;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment