Need help with a SOQL Query. We are trying to pull our highest sales records by month and user. Looking to see something like: "John Doe 100 Sales May 2014. Currently I am getting the calendar month, but not the year. Below is what I have currently, any suggestions are appreciated!
SELECT Count(Id), Sold_By__r.Name, calendar_month(Sold_By_Date__c) FROM Case WHERE Status = 'Sold' AND Sold_By__c !='005U0000000aL0BIAU' AND Sold_By__c !='' GROUP BY Sold_By__r.Name, calendar_month(Sold_By_Date__c) ORDER BY Count(Id) DESC LIMIT 10