카테고리 없음
[LeetCode] 1393. Capital Gainloss [MySQL]
치킨먹고싶어요
2022. 6. 17. 17:26
https://leetcode.com/problems/capital-gainloss/
Capital Gain/Loss - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
|
SELECT stock_name, SUM(
CASE WHEN operation = 'Buy' THEN -price
ELSE price
END
) AS capital_gain_loss
FROM Stocks
GROUP BY stock_name
|
cs |