我有一个查询,其中我从表'tickets‘中最常见的用户ID中获得用户id和行数。但是现在,我想执行相同的查询,但它需要在我插入的两个日期时间之间进行搜索。(有一列具有日期时间值('created_at')) 这是我的代码: SELECT created_by,COUNT(*) as tickets_countWHERE created_at
group by created_by having count(*) =(select max(tickets_count) from (select created_by,count(*) as