Ci provo ...
codice:
SELECT (SELECT COUNT(campo) FROM tabella WHERE time<x) AS a,
           (SELECT COUNT(campo) FROM tabella WHERE time>x AND time<y) AS b,
           (SELECT COUNT(campo) FROM tabella WHERE time>y) AS c
HTH
Zappa