title: How to get count of each item in sqlite group by specific column
body: <p>suppose that I have an android sqlite database with person names and place
  like :</p>
  
  <p><strong>Names</strong> | <strong>country</strong> | <strong>age</strong></p>
  
  <p>Sam  | Canada | 22</p>
  
  <p>Sara | Brazil | 25</p>
  
  <p>Jack | UK     | 20</p>
  
  <p>Anna | Brazil | 29</p>
  
  <p>Jessica | Uk | 20</p>
  
  <p>Steve | UK | 31</p>
  
  <p>Selena | Brazil | 20</p>
  
  <p>Shaki | UK | 27</p>
  
  <p>I want to have each each country with the number of person in it</p>
  
  <p><strong>like this</strong></p>
  
  <p>Uk 4</p>
  
  <p>Brazil 3</p>
  
  <p>Canada 1</p>
  
  <p>how to query this ?!</p>
  
  <p>I queried this </p>
  
  <pre><code>Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null,KEY_CITY, null, null); 
  </code></pre>
  
  <p>but it's just display the <code>DISTINCT country</code> without the count</p>
  
  <p><strong>thanks</strong></p>