• Home
• com.github.javadev
• leetcode-in-kotlin
• 1.21
• source code
• script.sql

×

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.

g1101_1200.s1193_monthly_transactions_i.script.sql Maven / Gradle / Ivy

# Write your MySQL query statement below
# #Medium #Database #2023_06_08_Time_891_ms_(92.73%)_Space_0B_(100.00%)
SELECT
    FORMATDATETIME(trans_date, 'yyyy-MM') AS trans_month,
    country,
    COUNT(*) AS trans_count,
    SUM(CASE WHEN state = 'approved' THEN 1 ELSE 0 END) AS approved_count,
    SUM(amount) AS trans_total_amount,
    SUM(CASE WHEN state = 'approved' THEN amount ELSE 0 END) AS approved_total_amount
FROM Transactions
GROUP BY trans_month, country;