title: sql join 2 rows in the same table
body: <p>I have the following table:</p>
  
  <pre><code>Name   Type     Value
  ---------------------
  mike   phone    123    
  mike   address  nyc    
  bob    address  nj    
  bob    phone    333
  </code></pre>
  
  <p>I want to have the result like this:</p>
  
  <pre><code>name  value  value
  -------------------
  mike  nyc    123
  bob   nj     333
  </code></pre>
  
  <p>How can I do it?</p>