title: Oracle SQL - Count number of jobs per month
body: <p>I'm looking to count the total number of time a type of job (G012) has appeared each month with an status_code of '5200' in each area.</p>
  
  <p>The code I have so far is:</p>
  
  <pre><code>select area.area_name, count(area.area_name)
  from area
  inner join central_site on central_site.area_code = area.area_code
  inner join job on job.site_code = central_site.site_code
  inner join job_type on job.job_type_key = job_type.job_type_key
  inner join job_status_log on job.job_number = job_status_log.job_number
  where job_type.job_type_key = 'G012' and job_status_log.status_code = '5200'
  group by area.area_name
  order by area.area_name
  </code></pre>
  
  <p>I'm not sure how to get this to count so that each month is in a different category - but what I would like to end up with is something like:</p>
  
  <pre><code>Area             April     May     June    July    August    September    October
  North Ward         2        5        3       2        7         4            3
  South Ward         2        3        4       4        6         4            4
  </code></pre>