title: Count number of male and female
body: <p>i want to count  no of male and female in a table called Gender having entry given below. Answer should be female=2 Male=3 in count.
  Is there any query in SQL.</p>
  
  <pre><code>Gender
  MALE
  MaLE
  FEMALE
  Female
  </code></pre>