title: mysql query with clause
body: <p>I have a table like this which has values 5,10,900,1800,50,100 
  These values shows </p>
  
  <p>5 responses and price is 10, </p>
  
  <p>900 responses and price is 1800</p>
  
  <p>50 responses and price is 100</p>
  
  <p><img src="https://i.stack.imgur.com/UrU7G.jpg" alt="enter image description here"></p>
  
  <p>Now i want the result of these values as price sum which should display like this</p>
  
  <p><img src="https://i.stack.imgur.com/3zUxA.jpg" alt="enter image description here"></p>
  
  <p>Responses values should display as it is but sum of prices values should display only one at the end of responses. </p>
  
  <p>I read that this could be done by using common table expressions but unfortunately mysql doesn't supports cte. and i am stuck here what other possible solutions are to this particular problem.</p>