12.股票的资本损益
链接:https://leetcode-cn.com/problems/capital-gainloss/
--使用if函数
select stock_name, sum(
if(operation = "Buy",-price,price)
) capital_gain_loss
from Stocks
group by stock_name
--使用case 通过case(when when)end 对特定数据处理
select stock_name, sum(
case
when operation = "Buy" then 0-price
when operation = "Sell" then price
end
) capital_gain_loss
from Stocks
group by stock_name