I have a table with 2 columns, one for id and one for country.

I've found some rows in the table where it looks like the below:

| ID | Country |
| --- | --- |
| 1 | US and Canada |
| 2 | France and UK |

How can I write a query so that I find the rows and split the column so
I get the following result.

| ID | Country |
| --- | --- |
| 1 | US |
| 1 | Canada |
| 2 | France |
| 2 | UK |