leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE |
1193.sql (328B)
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