---

SELECT 
    g.name AS group_name,
    p.datep,
    s.NAME,
    a.number,
    t.surname AS teacher_surname
FROM GROUPS g
JOIN PAIR p ON p.groups_id = g.id
JOIN TEACHER t ON p.subject_id = t.SUBJECT_ID
JOIN SUBJECT s ON p.subject_id = s.id
JOIN AUDITOR a ON a.ID = p.auditor_id
WHERE 
    p.datep LIKE '23.09.2026%'
     AND a.number IN (309, 311)
     AND g.number IN (1, 2, 4)
     AND (t.surname LIKE 'К%' OR t.surname LIKE 'З%')
	 AND (s.name = "информатика" OR s.name = "Защита баз данных" OR s.name = "Проектир и разраб баз данных")
;