title: How can I count names and insert it as a column in SQL?
body: <p>I have a table in SQLite which has two columns (name and age). Something like this:</p>
  
  <p>Ann   29<br>
  John  30<br>
  Mark  14<br>
  Ann   18<br>
  Brian 45<br>
  Brian 21<br>
  Brian 19</p>
  
  <p>I would like to add a third column to this table and show how many times this name is repeated (I don't care about the age). Something like this:</p>
  
  <p>Ann   29  2<br>
  John  30  1<br>
  Mark  14  1<br>
  Ann   18  2<br>
  Brian 45  3<br>
  Brian 21  3<br>
  Brian 19  3  </p>
  
  <p>How can I do it in SQL (SQLite)?</p>