leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE | |
1193.sql (328B)
1 SELECT LEFT(trans_date, 7) AS month, 2 country, 3 COUNT(*) AS trans_count, 4 SUM(state = 'approved') AS approved_count, 5 SUM(amount) AS trans_total_amount, 6 SUM(if(state = 'approved', amount, 0)) AS approved_total_amount 7 FROM Transactions 8 GROUP BY YEAR(trans_date), MONTH(trans_date), country