K1000 - Service Desk Category Top 10
The "TOP 10" syntax is specific to Oracle and does not work in MySQL. At the bottom of your query (after the "group by CATEGORY" line), add the following.
First, to order the tickets from highest count to lowest:
order by Count_Of_Tickets desc
Second, to get only the first 10 records returned: