I've got a table (Countries) which only contains 1 column (Country).
I've got a table (Essays) which has several columns, though I'm only interested in the "RawText" column.

I can readily run the following:

```
select count(Id) Occurences
from Essays
where Essays.RawText like '%canada%';

```

I'd like to be able to run 1 query that iterates through the long list of countries.

Ideally I'd be able to return a table such as:

```
Canada 10
USA    45
Mexico 39

```

...

How do I go about searching for all the countries?