22,300
社区成员




select 日期,
[0-10t]=sum(case when 重量 between 0 and 10 then 1 else 0 end),
[10-20t]=sum(case when 重量 between 10 and 20 then 1 else 0 end),
[20-30t]=sum(case when 重量 between 20 and 30 then 1 else 0 end),
[30-40t]=sum(case when 重量 between 30 and 40 then 1 else 0 end),
[>40t]=sum(case when 重量 >40 then 1 else 0 end)
from tb
group by 日期