title: Select sum where clause SQL
body: <p>I have the following code, it works but I am trying to separate SUM for each Banksphere.servicio_id column, this code SUM only one servicio_id... I'm a bit lost, can someone help me? </p>
  
  <p>As you can see, every WHERE clause is exactly the same but Banksphere.peticion_id which is the only one that changes... So maybe there's some better way just to filter once the common clauses and leave only peticion_id for OK and KO?</p>
  
  <pre><code>SELECT
  (SELECT
      SUM(valor)
  FROM
      Banksphere
  WHERE
      Banksphere.fecha = '2013-01-14'
  AND
      Banksphere.servicio_id = '6'
  AND
      Banksphere.entidad_id = '2'
  AND
      Banksphere.peticion_id = '0') AS OK,
  (SELECT
      SUM(valor)
  FROM
      Banksphere
  WHERE
      Banksphere.fecha = '2013-01-14'
  AND
      Banksphere.servicio_id = '6'
  AND
      Banksphere.entidad_id = '2'
  AND
      Banksphere.peticion_id = '1') AS KO
  </code></pre>
  
  <p>EDIT WITH WORKING CODE</p>
  
  <pre><code>SELECT  Servicios.nombre as servicio,
          SUM(case when peticion_id = '0' then valor end) as OK,
          SUM(case when peticion_id = '1' then valor end) as KO
  FROM    Banksphere
  INNER JOIN
      Servicios
  ON
      Banksphere.servicio_id = Servicios.id
  WHERE   Banksphere.fecha = '2013-01-14'
          AND Banksphere.entidad_id = '2'
          AND Banksphere.peticion_id in ('0', '1')
  group by Servicios.nombre
  </code></pre>