Re: Query Help

[Peter Brawley]

Is this what you mean?

select 
  class,  
  week(insert_time) as wk, 
  count(*) as count, 
  sum( if(host is null or host='',1,0) ) as 'Invalid hosts'
from alarms
where insert_time > '2016-07-01 00:00:00' 
group by class,wk ;