title: MySql Count the same value
body: <p>I have this table. My task is this : <strong>Count the students having the same first name.</strong></p>
  
  <p>I want it to show me just the firstname and then how many times firstname is found:</p>
  
  <p>like this:  <code>bob | 2</code></p>
  
  <pre class="lang-none prettyprint-override"><code>id      firstN   lastN      group  grade    tax     gender  year    university 
  9       Alyson   Hanniga    112     1       0       female  1       UTC
  5       Barney   Stinson    111     4       0       male    1       UBB
  8       Bob      Saget      111     6       900     male    3       UBB
  14      Bob      Bob        112     10      250     male    1       UBB
  11      Cobie    Smulder    111     9       200     female  1       Dragos Voda
  7       David    Henrie     112     9       0       male    1       Dragos Voda
  12      Jason    Segel      112     10      150     male    1       UTC
  13      Josh     Radnor     112     7       0       male    2       Dragos Voda
  4       Lily     Aldrin     112     5       400     female  1       UBB
  6       Lyndsy   Fonseca    113     10      0       female  3       UTC
  2       Marshal  Eriksen    112     10      100     male    2       UTC
  10      Neil     Patrick    112     7       0       male    3       Dragos Voda
  1       Robin    Scherba    111     10      0       female  1       UBB
  3       Ted      Mosby      112     8       0       male    2       UBB
  </code></pre>