SELECT Processed_By as User, COUNT(Processed_By) as Count FROM Data WHERE Processed_Date >= '2004-1-1' And Processed_Date <= '2004-3-2' GROUP BY Processed_By ORDER BY Count DESC;
Doesn't show the statistics between the beginning of this year and yesterday. If I use 2004-3-3 (today) as enddate it works fine. But maybe that this search query can be done easier or more accurate?