title: Generated a percentage based (not counted based) frequency table in SQL
body: <p>I would like to make a frequency table that is percent based with a single SQL statement. So if I have a table of men and women like this:</p>
  
  <pre><code>Name    Gender   
  Allen    M
  Jerry    M
  Marsha   F
  Alice    F
  </code></pre>
  
  <p>I'd like to end with this table:</p>
  
  <pre><code>Gender   Freq
  M        .50
  F        .50
  </code></pre>
  
  <p>I know I can count and group, but how can I divide the counts by group by the total count of the table?</p>