title: How to rename result set of COUNT(*) in SQL
body: <p>We were asked to create a SQL statement to show the count of customers whose country is USA. The column name of the result set should then be renamed into <code>numcustomers</code>.</p>
  
  <p>The database is in here: <a href="http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all" rel="noreferrer">http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all</a>.</p>
  
  <p>I already found the count(*) of customers in the USA:</p>
  
  <pre><code>SELECT * 
  FROM Customers
  WHERE Country = 'Germany'
  </code></pre>
  
  <p>But I can't figure out how to rename <code>COUNT(*)</code> into <code>numcustomers</code>. Any help? </p>