select * from group_reviews a
JOIN subjects b
ON a.subject_id = b.id
where b.name = 'Английский язык'

delete from group_tests where group_id = 1

select * from student_results a
JOIN  group_tests b
ON a.test_id = b.test_id
where group_id = 1

delete from students where student_id = 16 OR 
student_id = 17 OR student_id = 20 OR 
student_id = 21 OR student_id = 16 OR 
student_id = 23 OR student_id = 33