리트코드(LeetCode) SQL 문제풀이 - 1393. Capital Gain/Loss

MySQL 문제 1393. Capital Gain/Loss

select stock_name, SUM(
    CASE 
        WHEN operation='Buy' THEN -price 
        ELSE price
    END
    ) as capital_gain_loss
    from Stocks
    group by stock_name;