I have a table
PEOPLE, DATE, DELETED
now I need to group it and sum it with months like this:
so new people should not be counted in previous month but they should be in next months for my range (January - June). And if man is DELETED, he should be counted together with another people last time in month when he has been deleted.
How to write query for this?
要补齐空缺的月份，用 SQL 需要 JOIN 子查询才能实现，代码比较复杂，这种情况下建议用 SPL 实现：
|2||=A1.query(“SELECT * FROM tb1”)|
|3||=to(3,7).new(~:month,A2.count(month(DATE)<=month)-A2.count(DELETED && month(DELETED)<month):count)|
A3：统计 3 到 7 月份在职人员数量