测试数据准备
data2 = table(10000:0, `device`noise`day, `INT`INT`DATE);
noise1 = rand(80,364) ;
noise2 = rand(80, 364);
device = rand(1..10, 364);
day = 2022.01.01..2022.12.30;
data2.append!(table(device, noise1, day));
data2.append!(table(device, noise2, day));
select * from data2;
场景1 按天/月/年统计噪声分布
select
count(iif(noise < 30, noise, NULL)) as part1_num
,count(iif(noise>= 30 && noise<40, noise, NULL)) as part2_num
from data2
group by day
场景2 按天统计噪声最大,最小,平均值
select
max(noise) as max_noise
,min(noise) as min_noise
,avg(noise) as avg_noise
from data2
group by day