group by clause

[Fabio Bernardo]

hi there
I wrote this querie :
select  pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
status<>'C' group by pop,prot,sw_or_local
And I have this result :

+--------+--------+-------------+--------+
| pop    | prot   | sw_or_local | sum   |
+--------+--------+-------------+--------+
|    BHE |   R2 |      local        50
 |     
|    BHE |     R2 |      local       12
 |    
+--------+--------+-------------+--------+
  .
 .
 .
 .
.
Have you see,? I would like something like that:
| pop    | prot   | sw_or_local | sum   |
+--------+--------+-------------+--------+
|    BHE |   R2 |      local        62
Is my group by querie wrong...?