title: How to aggregate values inside a column in SQL?
body: <p>I could not solve this question, any help?</p>
  <p>Batsman_detail table has the columns ,
  [Opposition (varchar), runs(int), dismissal(varchar), venue(varchar)]:</p>
  <ul>
  <li><p><code>opposition</code> column has may countries in it.</p>
  </li>
  <li><p><code>runs</code> column has the amount of runs scored by the batsman in that match.</p>
  </li>
  <li><p><code>dimissal</code> column has any of the following values caught/bowled/run out/not out.</p>
  </li>
  <li><p><code>venue</code> column has the stadium name where the match is held.</p>
  </li>
  </ul>
  <p>Now you should write a query such that the output table must have that number of times the batsman had gone out in a type of dismissal against the countries Pakistan,Australia and Srilanka (Original table contains many countries.),</p>
  <p>Example output format :</p>
  <pre><code>opposition                caught     bowled      runout      notout    
  Pakistan                  3              5               7               9   
  Australia                 0              4               4               1    
  Sri Lanka                 4              2               3               4
  </code></pre>