Mysql Order By Category And Subcategory

I am trying to sort some Nagios alerts in MySQL. I would like column 2 to be grouped together as it is now. All alerts are grouped. The problem is that i would like those groups to

Solution 1:

At the end of the query just make sure you specify the order in the order by clause

Order by host asc, event asc, event_count desc