1193. 每月交易 I

题目我就不写了，给出代码下次看的时候应该就知道什么题目了。

SELECT DATE_FORMAT(trans_date, '%Y-%m') AS month, 
       country, 
       COUNT(country) 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 month, country

记录这题的原因就是这个DATE_FORMAT函数，就是日期格式转换函数，用法就是

# 参数为要转换格式的日期，和转换后的形式
DATE_FORMAT(trans_date, '%Y-%m')