[LeetCode] 1393. Capital Gain/Loss

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT stock_name
     , SUM(CASE WHEN operation = 'Buy'
                THEN price * (-1)
            WHEN operation = 'Sell'
                THEN price
        END) AS capital_gain_loss
FROM Stocks
GROUP BY stock_name