Query to count occurrences of distinct values

Thank you for your reply, @Anaisdg

Shown in the screenshot below is “Major” and “Audit”, but there are also events of “Minor”:

With count():

I would like to achieve to have a table with the total number of “Major” events, the total number of “Minor” events, etc.