SELECT s.name, COUNT(DISTINCT f.name) FROM sheldule h, groups g, facultys f, subjects s
    WHERE f.id = g.faculty_id
    AND g.id = h.GROUP_ID
    AND s.id = h.subject_id
    AND h.day_date BETWEEN TO_DATE('2022-01-07','YYYY-MM-DD') AND TO_DATE('2022-07-01','YYYY-MM-DD')
GROUP BY s.name
HAVING COUNT(DISTINCT f.name) > 1;