title: Multiple counts in one SQL query with grouping
body: <p>I want to run a query to get a count of open incident and closed incidents grouped by year and month, the below query works fine without the grouping, but once I add the group it will not work!</p>
  
  <pre><code>SELECT (SELECT COUNT(*) AS Opened FROM Incidents) AS Total 
         (SELECT COUNT(*) AS Solved FROM Incidents WHERE (MONTH(Closedate)=MONTH(Opendate))) AS Solved
  GROUP BY YEAR(Incidents.Opendate)
  </code></pre>