select students.n_gr
from students
where
  sum(iif(students.avg_ball >= 4, 1, 0)) / count(students.n_z) >= 0.5
group by students.n_gr