title: How to calculate percentage in sql?
body: <p>I have to calculate percentage based on count. Given below is a sample data table.</p>
  
  <pre><code>TeamName   Count1   Count0
  --------   -----    ------
  Team1        1        2
  Team2        3        0
  Team3        1        1
  </code></pre>
  
  <p>I want to display the percentage based on the <code>greatest value</code> in <code>Count1</code>. <code>The expecting output sample is given below:</code></p>
  
  <p>Expecting Out Put :</p>
  
  <pre><code>TeamName   Count1   Count0  Percentage1  Percentage0
  --------   -----    ------  -----------  -----------
  Team1        1        2        33.33%         66.6%
  Team2        3        0        100%           0%
  Team3        1        1        33.33%         33.33%  
  </code></pre>
  
  <p>Help me to find a proper solution. Thank You.</p>