title: SQL Summarizing the number of days in each month from a data set
body: <p>I have a table that looks like this and I want to be able to summarize by ReportID the following.  There should be one listing for a ReportID and type and the number of days in each month under the listed months.   I don't want to have to figure out the begin and end date for the dataset, it should be automatic.</p>
  <p>[<img src="https://i.stack.imgur.com/3FtkL.png" alt="Results1" /></p>
  <p>.</p>
  <p>[<img src="https://i.stack.imgur.com/Kw7Fp.png" alt="Sample Table2" /></p>