Leetcode Problem 1193. Monthly Transactions I

1193. Monthly Transactions I

Leetcode Solutions

Use the DATE_FORMAT function to extract the year and month from the trans_date column and alias it as month.
Select the country column as is.
Use the COUNT function to count the total number of transactions for each group and alias it as trans_count.
Use the SUM function with a CASE WHEN expression to count the number of approved transactions and alias it as approved_count.
Use the SUM function to calculate the total amount of transactions for each group and alias it as trans_total_amount.
Use the SUM function with a CASE WHEN expression to calculate the total amount of approved transactions and alias it as approved_total_amount.
Group the results by the formatted month and country.


erDiagram
    Transactions {
        int id PK
        varchar country
        enum state
        int amount
        date trans_date
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen