SQL 문제 29 - Capital Gain/Loss LeetCode 1393


SQL 문제 29 - Capital Gain/Loss LeetCode 1393

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