mysql - 如何对日期字段进行分组以获取 MySQL 中的季度结果？

Question

我有一个工作表，用于保存工作，leaddate 是工作条目的字段。

我想要得到的结果是我每个季度的工作数量。我的查询对 Leaddate 字段中每个日期的作业进行计数。

这是查询

select count(jobid) as jobcount, leaddate
from jobs
where contactid='19249'
group by leaddate

Answer 1

我认为这应该可以完成工作:

SELECT YEAR(leaddate) AS year, QUARTER(leaddate) AS quarter, COUNT(jobid) AS jobcount
  FROM jobs
 WHERE contactid = '19249'
 GROUP BY YEAR(leaddate), QUARTER(leaddate)
 ORDER BY YEAR(leaddate), QUARTER(leaddate)