leetcode

0 SELECT LEFT(trans_date, 7) AS month,

1 country,

2 COUNT(*) AS trans_count,

3 SUM(state = 'approved') AS approved_count,

4 SUM(amount) AS trans_total_amount,

5 SUM(if(state = 'approved', amount, 0)) AS approved_total_amount

6 FROM Transactions

7 GROUP BY YEAR(trans_date), MONTH(trans_date), country