I have a problem with this query

```
select alarmas, count(alarmas) 
from lista_equipos 
where alarmas not like'%n/a%' 
group by alarmas;

```

the result don't consolidate the major alarm count.

```
Critical    6
Major       1
Major       9

```

Warning 36
[![enter image description here](https://i.stack.imgur.com/0lbfN.png)](https://i.stack.imgur.com/0lbfN.png)
[![enter image description here](https://i.stack.imgur.com/IIe3x.png)](https://i.stack.imgur.com/IIe3x.png)