title: Count number of rows which contains same value
body: <p>What is the MySQL query to count the total number of rows which contains the same value.
  For example:</p>
  
  <p>Consider a table <code>animal</code> which contains all animal names. If there are 5 rows in the table which contains the value <code>name</code> as <code>'cow'</code> then what would be the query for it?</p>