SELECT count(*) as cnt
     , max(time) as MAX
     , min(time) as MIN
     , attacksignature 
  from np_data 
 where month=? and day=? 
 group by attacksignature 
 order by cnt desc