t11a · January 17, 2014 16:53 · t11a · Jan 17, 2014 · t11a · Jan 17, 2014
diff --git a/5_min_interval.sql b/5_min_interval.sql
 select FROM_UNIXTIME(TRUNCATE(UNIX_TIMESTAMP(addtime(created_at,'09:00:00'))/300,0)*300) as _time, count(*)
 from sales
 where
 created_at between '2014-01-17 15:00:00' and '2014-01-18 14:59:59'
 GROUP BY _time;
	select FROM_UNIXTIME(TRUNCATE(UNIX_TIMESTAMP(addtime(created_at,'09:00:00'))/300,0)300) as _time, count()
	from sales
	where
	created_at between '2014-01-17 15:00:00' and '2014-01-18 14:59:59'
	GROUP BY _time;