title: Ignite: SQL query to calculate probability of a column
body: <pre><code>Gender
  -------
  Female
  Male
  Male
  Male
  Female
  Female
  Male
  Female
  </code></pre>
  
  <p>Here i want to calculate probability of gender column and following query i tried, but it's not working.</p>
  
  <pre><code>SELECT (count(*)/(SELECT count(*) from DIABETIC_TOPIC) as probability from DIABETIC_TOPIC group by gender order by gender;
  </code></pre>
  
  <p>what i missed?</p>