mysql - 使用 Group BY 按条件查询列计数

Question

表结构

id(int)
dated_on(datetime)
(many_more)

表中包含按 ID 分组的数千条数据。

I want result as id, count of that id, 
also count of id having date difference is week.(i.e. count of data last week)

Answer 1

select
id,
count(id) as cnt,
sum(if(now() - interval 7 day <= dated_on,1,0)) as lastweek
from table
group by id