---

SELECT CONCAT('«', SPECIALNOST.SPECIALNOST_ID, '.', SPECIALNOST.SPECIALNOST, '»') AS 'Код и Специальность', CONCAT('«', KAFEDRA.KAFEDRA, '»') AS 'Кафедра', CONCAT('«', GRUPPA.GRUPPA, ' гр.»') AS 'Группа', CONCAT('«', SUBJECT.SUBJECT, '»') AS 'Предмет' FROM GRUPPA JOIN FACULTY ON GRUPPA.FK_FACULTY_ID = FACULTY.FACULTY_ID JOIN SPECIALNOST ON GRUPPA.FK_SPECIALNOST_ID = SPECIALNOST.SPECIALNOST_ID JOIN KAFEDRA ON SPECIALNOST.FK_KAFEDRA_ID = KAFEDRA.KAFEDRA_ID JOIN STUD ON GRUPPA.GRUPPA_ID = STUD.FK_GRUPPA_ID JOIN ACKBOOK ON STUD.STUD_ID = ACKBOOK.FK_STUD_ID JOIN EKZAMEN ON ACKBOOK.FK_EKZAMEN_ID = EKZAMEN.EKZAMEN_ID JOIN SUBJECT ON EKZAMEN.FK_SUBJECT_ID = SUBJECT.SUBJECT_ID WHERE FACULTY.FACULTY = 'ИФМО' AND SUBJECT.SUBJECT <> '';