title: mysql query group by/order by count
body: <p>Here is a table:</p>
  
  <pre><code>ID    Item  status  updatetime   author
  1     a     1       2014-01-02   Mike
  2     a     1       2014-02-01   Jack
  3     b     2       2014-01-10   John
  4     b     1       2014-10-10   Ben
  5     b     2       2014-01-11   Sam
  6     c     3       2014-01-02   Aron
  7     c     1       2014-11-01   Aron
  8     c     1       2014-10-20   Max
  9     d     3       2014-10-20   Mike
  </code></pre>
  
  <p>I would like to count the total number of each status for each Item, and the latest date/author of the items</p>
  
  <p>The result should be like this:</p>
  
  <p>count(status) =2 when item=a and status=1</p>
  
  <p>count(status) =0 when item=a and status=2</p>
  
  <p>count(status) =0 when item=a and status=3</p>
  
  <pre><code>Item    status_1    status_2    status_3    Latestupdate    author
  a        2            0           0         2014-02-01       Jack
  b        1            2           0         2014-10-10       Ben
  c        2            0           1         2014-11-01       Aron
  d        0            0           1         2014-10-20       Mike
  </code></pre>
  
  <p>How to write the sql ？</p>