title: Is there a way to find percentage of non-zero vs zero values in one column?
body: <p>I'm supposed to find the percentage of people having received aid.</p>
  
  <p>I'm assuming the best way to do this is find the number rows who received 0 aid, and the number of rows that have a greater than 0 value, create two variables for those and divide accordingly to find the percentage.  It's been a while since I've worked with sql so this is challenging me.</p>
  
  <pre><code>select
      rprawrd_aidy_code as year,
      sum(rprawrd_accept_amt)
  
  from
      rprawrd
  
  where
      rprawrd_aidy_code = '1819'
  
  group by
      rprawrd_aidy_code
  </code></pre>
  
  <p>This only gives me a total of the amount of aid provided for the year in question.  I need to figure out the total rows that received vs the total that didnt.</p>