SELECT text
      ,SUM(SUM) amount
      ,SUM(qty) qty
      ,SUM(decode(st,2,SUM,0)) sum_otkaz
      ,SUM(decode(st,2,qty,0)) qty_otkaz
      ,SUM(decode(st,1,SUM,0)) sum_okaz
      ,SUM(decode(st,1,qty,0)) qty_okaz
  FROM Q
GROUP BY text
ORDER BY text