1393. Capital Gain Loss

Tables

erDiagram
	Stocks {
		stock_name varchar PK
		operation enum "Sell, Buy"
		operation_day int PK
		price int
	}
Mermaid
복사

DataFlow

Buy -price, Sell +price -> groupby stock_name -> sum(Buy, Sell)

Answer

SELECT
	stock_name,
	SUM(amount) AS capital_gain_loss
FROM (
	SELECT
		stock_name,
		CASE WHEN operation = "Sell" THEN price ELSE (-1 * price) END AS amount
	FROM Stocks
) a
GROUP BY stock_name;
SQL
복사