title: How to combine the related version in group by
body: <pre><code>select count(a),b,c
  from APPLE
    join MANGO  on (APPLE.link=MANGO.link)
    join ORANGE  on (APPLE.link=ORANGE.link)
   where id='camel' 
  group by b,c;
  </code></pre>
  
  <p>The column b gives values like</p>
  
  <pre><code>1.0
  1.0,R
  1.0,B
  2.0
  2.0,B
  2.0,R
  3.0,C
  3.0,R
  </code></pre>
  
  <p>is there a way to modify the above query so that all 1.0 and 1.0,R and 1.0,B are merged as 1.0, and 2.0,2.0,B are merged as 2.0 and same way for 3.0 and 4.0?</p>