select t.name, count(h.lesson_id) from sheldule h, teachers t
where t.id = h.teacher_id
and h.day_date between to_date('2022-06-06','YYYY-MM-DD') and to_date('2022-06-12','YYYY-MM-DD')
group by t.name, h.day_date
having count(h.lesson_id) = (
    select count(teacher_id) from sheldule, teachers
    where
    day_date = h.day_date
    and sheldule.teacher_id = teachers.id
    and teachers.name = t.name
    group by lesson_id
    having count(teacher_id) > 1 )