我有一堆日期字段
Started Completed Status
---------- ---------- ----------
2000-01-30 2000-01-31 2000-01-31
2000-01-30 2000-02-01 2000-02-01
我需要在Status
个月前数到Started
和Completed
:
Started Completed Status
------- --------- ------
2 1 Jan-2000
. 1 Feb-2000
我已经得到了一些类似的东西
SELECT DATE_TRUNC('month', Status) AS Status,
SUM(IF(DATE_TRUNC('month', Started) = DATE_TRUNC('month', Status), 1, 0)) AS Started,
SUM(IF(DATE_TRUNC('month', Completed) = DATE_TRUNC('month', Status), 1, 0)) AS Completed
FROM table
GROUP BY Status
这给了我
Started Completed Status
------- --------- ------
1 1 Jan-2000
. 1 Feb-2000
我需要Started
岁才能在1月份成为2岁