title: Oracle10G SQL : Turning Columns into rows
body: <p>I need to turn columns into rows and get its average.</p>
  
  <p>For example I have this table:</p>
  
  <pre><code>Name   Math    Science     Computer
  ----   ----    -------     --------
  Ted    90       89          95
  Zed    99       98          98
  Fed    85       75          90
  </code></pre>
  
  <p>The output should be:</p>
  
  <pre><code>Subject      Average
  -------      -------
  Math         88
  Science      87.33
  Computer     94.33
  </code></pre>
  
  <p>How can I achieve it? Thank you for the help.</p>