title: SQL SELECT Replace country names with abbreviations
body: <p>My query looks like this:</p>
  
  <pre><code>SELECT o.CustomerID, null emptyColumn, o.ShipFirstName, o.ShipCountry, c.EmailAddress
  
  FROM Orders o, Customers c
  
  WHERE o.CustomerID = c.CustomerID
  </code></pre>
  
  <p>And the results are like,</p>
  
  <pre class="lang-none prettyprint-override"><code>1,,John,United States,john@example.com
  2,,Peter,Canada,peter@example.com
  </code></pre>
  
  <p>But I need to change "United States" to "US" and "Canada" to "Ca". How can I do this?</p>