Re: Nested GroupBy or for each

[Peter Brawley]

Is this what you mean?

select measurement_campaign, sensor, if( n<4, -1, mean ) as mean
from (
  select measurement_campaign, sensor, count(*) as n, avg(measurement_result) as mean
  from tbl
  group by measurement_campaign, sensor
) means;