title: Display all values in a GROUP BY
body: <p>How do I get all the values in a group by statement?</p>
  
  <pre><code>mysql&gt;select * from mytable;
  +------+--------+--------+
  | name | amount | status |
  +------+--------+--------+
  | abc  |     12 | A      | 
  | abc  |     55 | A      | 
  | xyz  |     12 | B      | 
  | xyz  |     12 | C      | 
  +------+--------+--------+
  4 rows in set (0.00 sec)
  
  mysql&gt;select name, count(*) from mytable where status = 'A' group by name;
  +------+----------+
  | name | count(*) |
  +------+----------+
  | abc  |        2 | 
  +------+----------+
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>Expected result:</p>
  
  <pre><code>+------+----------+
  | name | count(*) |
  +------+----------+
  | abc  |        2 | 
  | xyz  |        0 | 
  +------+----------+
  </code></pre>