Insert into Mark (id_student,mark,date,id_discteacher)
Select student.id_student,'10','2019-05-09',id_discteacher from discipline_teacher
JOIN discipline using(id_discipline)
join teacher using(id_teacher)
join group on class.id_group = discipline_teacher.group
join student on student.group = group.id_group
where EXISTS (select * from discipline_teacher
             join group on discipline_teacher.group = group.id_group
              join student on student.group = group.id_group
              JOIN discipline using(id_discipline)
              join teacher using(id_teacher)
              where discipline.title ='math' and teacher.id_teacher=1 and group.title ='2' and group.kurs ='А')
              and discipline.title ='math' and teacher.id_teacher=1 and group.title ='2' and group.kurs ='А' and student.name = 'Anna' and student.last_name ='Makeeva';