[_Lynx_]

select n from
(select n, sum(activ)/count(*) ac from temp
group by n) where ac<0.8