title: SQL group dates by month
body: <p>I have a query that returns expiration dates:</p>
  
  <pre><code>    SELECT ci.accountnumber
             , ci.accountname
             , cvu.ExpirationDate
        FROM dbo.clientinfo ci
  INNER JOIN clientvehicleunit cvu ON ci.clientid = cvu.clientid
  </code></pre>
  
  <p>The expiration dates can be anytime during any month and any year.</p>
  
  <p>I need to return counts of how many units are due to expire within each month for a 12 month period....</p>
  
  <p>I have no idea how I would do this?</p>