title: How do I group a date field to get quarterly results in MySQL?
body: <p>I have a job table that holds jobs and leaddate is the field for the job entry.</p>
  
  <p>The result I want to get is the number of jobs I have in each quarter. My query counts jobs of each date in the leaddate field.</p>
  
  <p><strong>Here is the query</strong></p>
  
  <pre><code>select count(jobid) as jobcount, leaddate
  from jobs
  where contactid='19249'
  group by leaddate
  </code></pre>