title: Is it possible to group by certain values?
body: <p>i have an oracle database table with following values</p>
  
  <pre><code>+------+--------+
  | id   | Name   |
  +------+--------+
  |    0 | One    |
  |    1 | Two    |
  |    2 | Three  |
  |    3 | four   |
  |    4 | One    |
  |    5 | One    |
  |    6 | Two    |
  |    7 | five   |
  +------+--------+
  </code></pre>
  
  <p>i would like to count the number of rows having names 'One','Two',Rest of Names.
  the result set should be like</p>
  
  <pre><code>+------+--------+
  | name | count  |
  +------+--------+
  |  One | 3      |
  +------+--------+
  |  Two | 2      |
  +------+--------+
  |  Rest| 3      |
  +------+--------+
  </code></pre>
  
  <p>Any help?</p>