title: SUM of rows in My Sql with condition
body: <p>My Data is </p>
  
  <pre><code>ID       SCORE
   1        55
   1        -1
   1        25
   1        -1
   1        -1
   1        35
   2        25
   2        -1 
   2        65
   2        55
   2        21
   2        -1
  </code></pre>
  
  <p>Now i want to add/sum the score of each id ignoring -1 and i am trying with this code which is not working</p>
  
  <pre><code>SELECT SUM(CASE when SCORE&gt;-1 THEN SUM(SCORE) ELSE 0 END) 
  FROM jbit WHERE htno='$id'
  </code></pre>
  
  <p>Here i am already using WHERE so how can i use another WHERE, if i use multiple Where in single query it may effect other processes.. please help me out</p>
  
  <p>Help me out friends </p>