title: How to I get a total count?
body: <p>My current query returns the total number of people in each ethnic group as expected, for example:</p>
  
  <pre><code>Name        |   Count
  ----------------------
  White       |   22
  Asian       |   15
  Black       |   12
  </code></pre>
  
  <p>Etc. However I want to add a thrid column which returns each ethnic group as a percentage of the total, how would I go about this?</p>
  
  <pre><code>SELECT 
      eo.EthnicOriginName, 
      ISNULL(e.Number, '')
      --CAST(e.Number AS FLOAT) / CAST(COUNT(e.intEthnicOriginID) AS FLOAT)  * 100 
  
  FROM 
      tblEthnicOrigin eo
      INNER JOIN tblPerson p ON p.intEthnicOriginID = eo.EthnicOriginID
  
      LEFT JOIN (SELECT intEthnicOriginID, COUNT(p.intPersonID) [Number]
              FROM tblPerson p
              INNER JOIN tblClient c on c.intPersonID = p.intPersonID
              GROUP BY intEthnicOriginID) e on e.intEthnicOriginID = eo.EthnicOriginID
  
  GROUP BY
      eo.EthnicOriginName, e.Number
  </code></pre>