I currently am returning a table that looks like this:

```
Country  Result
------   -----
Japan    sunk
Japan    sunk
USA      ok
USA      ok

```

with country and result being the column names

Id like to know how many times japan and sunken show up? So the resulting query I am trying to achieve is:

```
country      numSunk
-------      ------
Japan        2
USA          0

```

I've tried grouping or doing a where result="sunk" but I keep getting errors. Any thoughts? Thanks.