how to generate queries based on date

[eluser]tusukgigi[/eluser]
if anyone other than this query?

SELECT dateflag, COUNT(*) AS num_stats
FROM stat
WHERE MONTH(dateflag)=MONTH(NOW()) AND YEAR(dateflag)=YEAR(NOW())


result :
dateflag | num_stats

2010-07-22 | 800