Sunbelt Computer Software

PL/B Language Development and Support

Leetcode/database/_1393.sql at master · Algorithm-box/Leetcode · GitHub

6 lines (6 loc) · 162 Bytes

select stock_name, sum(
        when operation = 'Buy' then -price
            else price
) as capital_gain_loss from Stocks group by stock_name;