mysql - 在单个查询中获取不同日期范围的多列计数

Question

按照我几天前的ojit_，我们能够得到想要的结果。现在我们有在图表上绘制事件计数的新要求，我们需要指定日期范围，并且结果将限制在日期范围(纪元)内。我可以使用两个单独的查询来完成此操作，如下所示，但这似乎不是一个好的选择。

问题

是否有其他方法可以将这两个查询合并在一个查询中，并在不同的结果集中获取这两个查询的结果？

select source_id
       sum(case when plateCategoryId = 3 then 1 else 0 end) as TotalNewCount,
       sum(case when plateCategoryId = 4 then 1 else 0 end) as TotalOldCount
from event where eventTime >= 1451606400 and eventTime <= 1454284800 
group by source_id;

select source_id
       sum(case when plateCategoryId = 3 then 1 else 0 end) as TotalNewCount,
       sum(case when plateCategoryId = 4 then 1 else 0 end) as TotalOldCount
from event where eventTime >= 1456790400 and eventTime <= 1459468800
group by source_id;

Answer 1

select source_id
       sum(case when plateCategoryId = 3 then 1 else 0 end) as TotalNewCount,
       sum(case when plateCategoryId = 4 then 1 else 0 end) as TotalOldCount
from event 
where (eventTime >= 1451606400 and eventTime <= 1454284800) OR
      (eventTime >= 1456790400 and eventTime <= 1459468800) 
group by source_id;