How do i write syntax to create custom column

Hi All, I want to create a custom column using a combination of two different columns in the table. For example, i have given sample table below, i want my end output as if Country equals to Canada ...