CODE EXAMPLE FOR SQL

postgres sum substract stackoverflow

SELECT sum(CASE event
             WHEN 'received' THEN
               quantity
             WHEN 'sent' THEN
               -quantity
             ELSE
               0
           END)
       FROM shipments;