LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 3220 - Odd and Even Transactions SUM CASE WHEN - Explained by Everyday Data Science

Question: https://leetcode.com/problems/odd-and-even-transactions/description/ SQL Schema: Create table if not exists transactions ( transaction_id int, amount int, transaction_date date) Truncate table transactions insert into transactions (transaction_id, amount, transaction_date) values ('1', '150', '2024-07-01') insert into transactions (transaction_id, amount, transaction_date) values ('2', '200', '2024-07-01') insert into transactions (transaction_id, amount, transaction_date) values ('3', '75', '2024-07-01') insert into transactions (transaction_id, amount, transaction_date) values ('4', '300', '2024-07-02') insert into transactions (transaction_id, amount, transaction_date) values ('5', '50', '2024-07-02') insert into transactions (transaction_id, amount, transaction_date) values ('6', '120', '2024-07-03') Pandas Schema: data = [[1, 150, '2024-07-01'], [2, 200, '2024-07-01'], [3, 75, '2024-07-01'], [4, 300, '2024-07-02'], [5, 50, '2024-07-02'], [6, 120, '2024-07-03']] transactions = pd.DataFrame( columns=["transaction_id", "amount", "transaction_date"], dtype={ "transaction_id": "int", "amount": "int", "transaction_date": "datetime64[ns]", }, ) #leetcodesolutions #datascience #sql