[LeetCode] 3220. Odd and Even Transactions

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT transaction_date
     , SUM(CASE WHEN MOD(amount, 2) = 1 THEN amount
            ELSE 0
        END) AS odd_sum
     , SUM(CASE WHEN MOD(amount, 2) = 0 THEN amount
            ELSE 0
        END) AS even_sum
FROM transactions
GROUP BY transaction_date
ORDER BY transaction_date ASC