title: Create custom column in SQL Query
body: <p>I have a table like this:</p>
  
  <pre><code>ITEM    PICTURE    CATEGORY    STOCK
   1      Mickey     Shirt        3
   2      Mickey     Jacket       2
   3      Donald     Jacket       0
   4      Donald     Shirt        6
   5      Donald     Hoodie       1
   6      Mickey     Hoodie       3
   7      Goofy      Shirt        1
   8      Goofy      Hoodie       2
   9      Goofy      Jacket       3
  </code></pre>
  
  <p>The ITEM column is auto increment</p>
  
  <p>I need an output like this:</p>
  
  <pre><code>PICTURE    HOODIE    JACKET    SHIRT
  Donald       1         0         6
  Goofy        2         3         1
  Mickey       3         2         3
  </code></pre>
  
  <p>Any idea how I can produce that output? Thank you</p>