7,714
社区成员
发帖
与我相关
我的任务
分享
SELECT 时间S AS 时间, Count(编号S) AS 编号
FROM [
SELECT str(Year(Min(时间)))+"年"+str(Month(Min(时间)))+"月" AS 时间S, 编号 AS 编号S
FROM works
GROUP BY 编号
]
GROUP BY 时间S
ORDER BY 时间S;
SELECT 时间S AS 时间, Count(编号S) AS 编号
FROM [
SELECT Min(时间) AS 时间S, 编号, Count(编号) AS 编号S
FROM works
GROUP BY 编号
]
GROUP BY 时间S
ORDER BY 时间S;