title: mySQLi query for a specific month and date and year
body: <p>I am using mySQl browser to test a specific query that does not seem to wish to work. I wish to pull data on specific year, day, month but not all three at once. for example my database is dated back to 1982 and i wish to pull the most called value of number1 in the month of april. Below is my current query</p>
  
  <pre><code>SELECT number1, COUNT(number1) most FROM draws GROUP BY number1 WHERE MONTH(Date) = 4 ORDER BY most DESC;
  </code></pre>