title: How to aggregate data and find min,max,avg of numeric columns in postgresql
body: <p>I need to aggregate the data to application and find the min,max,avg of numeric columns</p>
  
  <p>What I have</p>
  
  <pre><code>  Application  income   score_1
      ax          800        77
      ax          900        72
      ax          700        62    
      ax          600        55    
  </code></pre>
  
  <p>What I need</p>
  
  <pre><code>  Application  min(income) max(income)    avg(income)  min(score_1) max(score_1)    avg(score_1)
      ax          800           900              750        62           77           224.75         
  </code></pre>
  
  <p>I can write a query as </p>
  
  <pre><code>select min(income),max(income),avg(income),min(score_1),max(score_1),avg(score_1)
  from table name group by application; --IT WORKS..!!
  </code></pre>
  
  <p>But in the table I have 20 numeric columns where i need to get the statistics of min,max,avg of those into a table. Is there any approach of getting this done rather writing column names manually to get the avg,min ,max</p>