SQL 문제 29 - Capital Gain/Loss LeetCode 1393 Capital Gain/Loss 풀이 SELECT STOCK_NAME , SUM( CASE WHEN OPERATION = 'Buy' THEN -PRICE WHEN OPERATION = 'Sell' THEN PRICE ELSE 0 END ) AS CAPITAL_GAIN_LOSS FROM STOCKS GROUP BY STOCK_NAME; * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com...
SQL 문제 29 - Capital Gain/Loss LeetCode 1393에 대한 요약내용입니다.
자세한 내용은 아래에 원문링크를 확인해주시기 바랍니다.
#CapitalGainLoss_LeetCode1393
#SQL
#SQL_CapitalGainLoss
#SQL_CapitalGainLoss_LeetCode1393
#SQL_LeetCode1393
원문링크 : SQL 문제 29 - Capital Gain/Loss LeetCode 1393