select substr(students.n_gr, 0, 1), count(distinct students_hobby.h_name)
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_hobby.d_finish is null
group by substr(students.n_gr, 0, 1)