• Home
• com.github.javadev
• leetcode-in-java
• 1.38
• source code
• readme.md

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

g3201_3300.s3220_odd_and_even_transactions.readme.md Maven / Gradle / Ivy

3220\. Odd and Even Transactions

Medium

SQL Schema

Table: `transactions`

    +------------------+------+
    | Column Name      | Type |
    +------------------+------+
    | transaction_id   | int  |
    | amount           | int  |
    | transaction_date | date |
    +------------------+------+ 
    The transactions_id column uniquely identifies each row in this table.
    Each row of this table contains the transaction id, amount and transaction date. 

Write a solution to find the **sum of amounts** for **odd** and **even** transactions for each day. If there are no odd or even transactions for a specific date, display as `0`.

Return _the result table ordered by_ `transaction_date` _in **ascending** order_.

The result format is in the following example.

**Example:**

**Input:**

`transactions` table:

    +----------------+--------+------------------+
    | transaction_id | amount | transaction_date |
    +----------------+--------+------------------+
    | 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       |
    +----------------+--------+------------------+ 

**Output:**

    +------------------+---------+----------+
    | transaction_date | odd_sum | even_sum |
    +------------------+---------+----------+
    | 2024-07-01       | 75      | 350      |
    | 2024-07-02       | 0       | 350      |
    | 2024-07-03       | 0       | 120      |
    +------------------+---------+----------+ 

**Explanation:**

*   For transaction dates:
    *   2024-07-01:
        *   Sum of amounts for odd transactions: 75
        *   Sum of amounts for even transactions: 150 + 200 = 350
    *   2024-07-02:
        *   Sum of amounts for odd transactions: 0
        *   Sum of amounts for even transactions: 300 + 50 = 350
    *   2024-07-03:
        *   Sum of amounts for odd transactions: 0
        *   Sum of amounts for even transactions: 120

**Note:** The output table is ordered by `transaction_date` in ascending order.