title: Add a new entry in a column SQL
body: <p>I have a problem with SQL which I'm new to.</p>
  <p>I created this view:</p>
  <pre><code>CREATE VIEW country_customer 
  AS
      SELECT 
          country,
          COUNT(customer_id) total_customers
      FROM 
          customer
      GROUP BY 
          1
      ORDER BY 
          2 DESC;
  </code></pre>
  <p>And as output I got this table:</p>
  <p><img src="https://i.stack.imgur.com/yBNNP.png" alt="output" /></p>
  <p>My question is how can I group all the countries that have 1 customer under the value 'Other'. The value has to appear under the country column at the end.</p>
  <p>The result I'm looking for should be the column country with all the countries that has &gt; 1 customer and at the end Other with the sum of all the customers of the country with just 1.</p>
  <p>Thank you!</p>