title: How to get my required record with defined table
body: <p>Hi my table structure is shown as below</p>
  
  <p><a href="https://i.stack.imgur.com/tLadY.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>and with sql query I want to make it as below structure format</p>
  
  <p><a href="https://i.stack.imgur.com/GHskN.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>I have to make this with single sql query.</p>
  
  <p>Currently I had made this with excel feature
  Can I get any suggestion?</p>
  
  <pre><code>Questionid  Response        Response
     1        HighlyEngaged   HighlyEngaged
     2        VeryPrepared    VeryPrepared
     2        VeryPrepared1   VeryPrepared1
  
   to
  
   RowLabels        Count of Response
    1                1
    HighlyEngaged    1
    2                2 
    VeryPrepared     1
    VeryPrepared1    1
  </code></pre>