title: Get amount of customer per city and the total of customer per country One table
body: <p>I need these two SQL Scripts into one: to get amount of customer per city and the total of customer per country from AdventureWorks database</p>
  
  <p>I almost have it done, the problem is that I need to make one single <code>TABLE</code>, having problems with Multiple <code>COUNT</code> 's.</p>
  
  <pre><code> USE AdventureWorks2014
  SELECT person.Address.City, Count (*) AS Total
  FROM person.Address
  INNER JOIN person.StateProvince
      ON person.Address.StateProvinceID = person.StateProvince.StateProvinceID
  GROUP BY person.Address.City 
  ORDER BY Total DESC
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Os4JK.png" rel="nofollow noreferrer">First scrip Returns</a></p>
  
  <pre><code>USE AdventureWorks2014
  
  SELECT person.StateProvince.CountryRegionCode, Count (*) AS Total
  FROM person.Address
  INNER JOIN person.StateProvince
      ON person.Address.StateProvinceID = person.StateProvince.StateProvinceID
  GROUP BY person.StateProvince.CountryRegionCode 
  ORDER BY Total DESC
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/QgHSr.png" rel="nofollow noreferrer">Second script returns:</a></p>