title: How to use the result of two columns within same table in mysql
body: <p>I have a table with such kind of data in 2 columns:</p>
  
  <pre><code>TypeOfFruits | Production2014 |
  Mangoes         450
  Mangoes         100
  Berries         50
  Berries         75
  Mangoes         45
  Berries         25    
  </code></pre>
  
  <p>My question is: How can I query the data from those two columns so that I can get a result in new columns like:</p>
  
  <pre><code>production2014 for Mangoes | production2014 for Berries
  450                          50
  100                          75
  45                           25
  </code></pre>