title: Count records for every month in a year
body: <p>I have a table with total no of 1000 records in it.It has the following structure:</p>
  
  <pre><code>EMP_ID EMP_NAME PHONE_NO   ARR_DATE
  1        A        545454 2012/03/12
  </code></pre>
  
  <p>I want to calculate no of records for every month in year-2012 </p>
  
  <p>Is there any way that should solve my issue in a single shot?</p>
  
  <p>I tried: </p>
  
  <pre><code>select count(*) 
  from table_emp 
  where year(ARR_DATE) = '2012' and month(ARR_DATE) = '01'
  </code></pre>