Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement