search

QuXiangjie / Study-Review

自己欠缺的还太多了，希望通过总结每天的学习内容，整理每天的思绪来丰富自己的知识库。我想成为一名优秀的金融数据分析师，并行发展技术与商业业务。博客内容为：数理统计、财务业务、Python(数据分析及可视化)、Excel（数据分析）、SQL、英文
0 stars 0 forks source link

1193. Monthly Transactions I #32

Open QuXiangjie opened 4 months ago

QuXiangjie commented 4 months ago

1193. Monthly Transactions I

SELECT  DATE_FORMAT(trans_date, '%Y-%m') AS month, country, 
        COUNT(id) AS trans_count, 
        SUM(IF(state = 'approved',1,0)) AS approved_count,
        SUM(amount) AS trans_total_amount,
        SUM(IF(state = 'approved',amount,0)) AS approved_total_amount
FROM  Transactions
GROUP BY month,country