I'm editng my original request as I think i've confused myself as well as others. I want to do a count of incidents within the Continents. Sorry for the confusion

```
ID,  --a unique incident number

case 
when trim(both ' ' from cs.country) in ('France','UK',Germany) then 'Europe'
when trim(both ' ' from cs.country) in ('Argentina','Peru','Brazil') 
then 'SouthAmerica'      
when trim(both ' ' from cs.country) in ('Bangladesh,'India','China') 
then 'Asia'      
end as "Continent"

```

This is what I would like to see

```
      Continent      Total           
       Europe          15
       Asia            12
       Asia             9
       SouthAmerica     5

```

Many Thanks