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