mysql - 查询计数行的总和(过去 30 天)

Question

我有这张表 p_payments。该表包含 payment_amount、payment_status 和 createdtime 列:

p_payments
____________________________
payment_status      varchar(25)
payment_amount      decimal(7,2)
createdtime         datetime

我如何创建一个查询来计算过去 30 天的收入总和 WHERE payment_status = completed？

我的 table

payments_status     payment_amount     createdtime
----------------------------------------------------------
Completed               1.00           2013-09-29 21:45:02
Denied                  2.00
Failed                  1.50
... etc

Answer 1

SELECT Sum(payment_amount) 
FROM   p_payments 
WHERE  payments_status = 'completed' 
       AND createdtime >= Date_Sub(Curdate(), INTERVAL 30 day)