Query for requests with most common category/subcategory
I'm having trouble finding a query that will produce a report of requests (both incident and service) with the most common category/subcategory. I would like to use this to find trends of issues that need to be addressed. It may also provide information on training that is needed for end users or techs. Please let me know if there are any clarifications needed. Thank you for any assistance you may provide.