3220. Odd and Even Transactions

SQL

SELECT
  transaction_date,
  SUM(IF(amount % 2 = 1, amount, 0)) AS odd_sum,
  SUM(IF(amount % 2 = 0, amount, 0)) AS even_sum
FROM Transactions
GROUP BY 1
ORDER BY 1;