Query Report - most entered tickets

Can someone help me write a query report regarding, "Most Entered tickets by Requester"?
It will need Requester name, Location, amount of tickets, and be able to be done from certain date ranges. If possible.