select students_hobby.*
from students
  join students_hobby on students_hobby.n_z = students.n_z
  join hobby on hobby.h_name = students_hobby.h_name
where
  students.avg_ball between 3 and 4
  and students.n_gr like '3%'
  and students_hobby.d_finish is null