stats count as #PlanOpen,
count(eval(NumRows < 50)) as SmallPlans ,
count(eval(NumRows>=50 AND NumRows <200)) as MediumPlans,
count(eval(NumRows >=200)) as LargePlans
With a query such as above and a field SecsElapsed in each row, is there a way to get the average of that field for each category, namely SmallPlans, MediumPlans and LargePlans?
