title: Count specific values. Mysql
body: <p>I have a table that looks like:</p>
  
  <pre><code>field1 | field2
     1   | ready
     2   | ready
     1   | in_progress
     1   | ready
     2   | in_progress
  </code></pre>
  
  <p>How can i count number of "ready" fields for each field1?
  For this example answer must be:</p>
  
  <pre><code>field1 | field2
     1   |   2
     2   |   1
  </code></pre>