leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE |
1393.sql (212B)
0 SELECT 1 stock_name, 2 SUM( 3 CASE 4 WHEN operation = 'buy' THEN -price 5 WHEN operation = 'sell' THEN price 6 END 7 ) AS capital_gain_loss 8 FROM Stocks 9 GROUP BY stock_name