title: MySQL query on sum() while returning detail of a particular row
body: <p>I've got a table </p>
  
  <pre><code>id pos status price
  1 US 0 0 
  1 UK 1 0
  1 HK 2 100
  2 HK 0 0
  2 UK 1 200
  ...
  </code></pre>
  
  <p>and I want to show the sum(price) of each id while showing the pos of the record where status=0</p>
  
  <p>i.e.</p>
  
  <pre><code>id pos sum(price)
  1 US 100
  2 HK 200
  ...
  </code></pre>
  
  <p>Any way to do it without using temp table?</p>