SELECT timeid,
COUNT(CASE state WHEN 0 THEN 1 END) AS state_0,
COUNT(CASE state WHEN 1 THEN 1 END) AS state_1
FROM metromaster
GROUP BY timeid

--
David Portas
------------
Please reply only to the newsgroup
--