title: MySQL query group by with multiple sum values
body: <p>If you review this <a href="http://sqlfiddle.com/#!2/85415/1" rel="nofollow">SQL Fiddle</a>, you will see that the resulting data is grouped by Year and Type which means that there are 2 rows for each year.  I would like to only group on the year, and display the Sum of the A-type and the B-type on the same row.  </p>
  
  <p>Can someone please tell me how I would modify the sum statements in this query so that the first sum is only for the A-type, and the second sum is for the B-type?  Thanks.</p>