title: mySQL query giving inaccurate results
body: <p>This is my current query:</p>
  
  <pre><code>select baseball , const.cnt/count(*) as my_percent 
  from full_db3 inner join
   (select count(*) as cnt from full_db3 where gender = 'f') const
  group by baseball
  order by my_percent desc limit 10;
  </code></pre>
  
  <p>This yields inaccurate results. The possible values for <code>baseball</code> are TRUE and FALSE, which appear in my result's <code>baseball</code> column. However, the values for <code>my_percent</code> are all off. Not even close.</p>
  
  <p>If I run this query (different <code>GROUP BY</code>), I get the correct value in <code>my_percent</code> for FALSE, but TRUE isn't in the result.</p>
  
  <pre><code>select baseball , const.cnt/count(*) as my_percent 
  from full_db3 inner join
   (select count(*) as cnt from full_db3 where gender = 'f') const
  group by const.cnt
  order by my_percent desc limit 10;
  </code></pre>
  
  <p>What am I missing here?</p>