title: How to get number of half centuries, centuries and double hundreds for each player in MySQL
body: <p>I have table with this format</p>
  
  <pre><code>id| name | types |
  _________________
   1   sachin   100
   2   virat    50
   3   sachin   50
   4   sachin   50
   5   sachin   200
   6   virat    100
   7   virat    200
  </code></pre>
  
  <p>What I want to get as the result is now something like </p>
  
  <pre><code> name   | num of 50 |num of 100 |num of 200
   sachin |    2      |    1      | 1
   virat  |    1      |    1      | 1
  </code></pre>
  
  <p>What is the correct way to get here ??
  I tried using group by. But I didn't get there</p>
  
  <p>Any help?</p>
  
  <p>Thanks</p>