title: SQL Query: calculating percentage
body: <p>If I wanted to find the percentage of people that are from the zip code area of 12345, I would take the number of people with that zip code and divide it from the total number of people… what am I missing in the example query below? I can’t figure out how to display the percentage correctly. It just keeps saying 0%.</p>
  
  <pre><code>select (count(P.PERSON_ID) / (select count(*) from PERSON P)) * 100.00
  as “12345 Zip Code Percentage”
  from PERSON P
  where P.ZIP = '12345'
  </code></pre>
  
  <p>Thank you.</p>