I have the following SQL report to show tickets grouped in categories, however it's displaying ticket categories that were not used for the past week. How can I write in a function to not show categories with zero entries?

I am new to SQL, but why can I not just add after the "where": and count(category) > 0 ?