title: Dividing values by sum of colum
body: <p>What the table looks like:</p>
  
  <pre><code>name--value1---value2
  name1-----1-------4
  name2-----2-------6
  </code></pre>
  
  <p>Output should be:</p>
  
  <pre><code>name---value1---value2
  name1---.333-----.40      
  name2---.666-----.60
  </code></pre>
  
  <p>I  am trying:</p>
  
  <pre><code>select (value1/sum(value1), (value2/sum(value2)
  from table
  </code></pre>
  
  <p>and it outputs the values for name1 only. When I use group by, it shows a value of 1 for all the values.</p>
  
  <p>I am using MySQL Workbench</p>