title: MySQL Query: How to sum 3 different values in a column, showing total of each value in result set
body: <p>I have a table called inventory that includes two columns as follows:</p>
  
  <p><img src="https://i.stack.imgur.com/ST24o.png" alt="enter image description here"></p>
  
  <p>I would like to query this table to return a result set that lists how many items of each condition I have (column headers show in example below are not wanted in result set...just show here to give clarity):</p>
  
  <p><img src="https://i.stack.imgur.com/Xrylg.png" alt="enter image description here"></p>
  
  <p>I guess it would look something like:</p>
  
  <pre><code>  SELECT item, sum(condition???), sum(condition???), sum(condition???) 
      FROM inventory 
  GROUP BY item
  </code></pre>
  
  <p>How can I accomplish this? Thanks.</p>