title: PostgreSQL - making first row show as total of other rows
body: <p>Is there any way to make first row be different then the rest, so it would show total sum of the appropriate columns?</p>
  
  <p>For example:</p>
  
  <pre><code>      fruits|a|b|c
         total|3|4|6
        apples|1|2|3
       bananas|1|1|2
       oranges|1|1|1
  </code></pre>
  
  <p>Is it possible to make query like that or it is against the logic of sql? 
  It would be like this (ignoring the first row for now):</p>
  
  <pre><code>SELECT fruits, sum(a), sum(b), sum(c)
  FROM basket
  </code></pre>
  
  <p>So the first row would be different. It would show word 'total' instead of fruit name, and would show total sum of a (1+1+1=3), b (2+1+1=4) and c (3+2+1=6). Is it possible to do like that? Thanks</p>