title: Merge together similar values in oracle SQL
body: <p>I have this code </p>
  
  <pre><code>select t_order.wh_id, t_order.bill_to_code, t_pick_detail.pick_area, count(*) as "OUC"
  from t_order
  INNER JOIN t_pick_detail on t_order.order_number = t_pick_detail.order_number
  where t_order.wh_id = 'MP'
  group by t_order.bill_to_code, t_pick_detail.pick_area, t_order.wh_id
  </code></pre>
  
  <p>Which Produces this </p>
  
  <pre><code>MP      GPS1       165
  MP      GPS2       13
  MP      GPS3       19
  MP      BULK LIPS  128
  MP      PICK FACE  19
  MP             44
  MP      CLS    3
  </code></pre>
  
  <p>Now what I need to add to the code is something that can merge the 3 "GPSn" rows into one called like "GPS" while not changing the "GPSn" permanently, while still displaying all of the other data.</p>