Instantly share code, notes, and snippets.

Embed
What would you like to do?
BigQuery_minute_interval_SQL
select
(minute - 4) as minute,
count(*) as count
from
(
SELECT
minute(SEC_TO_TIMESTAMP(date)) as minute
FROM
[niconico_comment.trans_jk8_9_bs211]
where
date >= 1453910700
and date <= 1453912500
and thread = 1453834808
)
group by
minute
order by
minute
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment