Capital Gain,Loss.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT stock_name, SUM(IF(operation="Buy", -price, price)) capital_gain_loss
FROM Stocks
GROUP BY stock_name;