LifeinAsia - 3:38 pm on Aug 25, 2010 (gmt 0)
WHERE Timestamp >= '1/1/2010' AND Timestamp <= '1/1/2011'
This will give you the count in 2010. You can get the other counts with similar queries. Some databases also support the BETWEEN operator (e.g., WHERE Timestamp BETWEEN '1/1/2010' AND '1/1/2011').
Note- "timestamp" may be a reserved word in your database, so you may want to change the field name to a non-reserved word.
Also, make sure you have an inde3x on the Timestamp field. Otherwise, the query will take a long time.