---

-- Простой SELECT
SELECT full_name, email FROM students WHERE department_id = 1;

-- Сложный JOIN: выписка студентов, их кафедр и факультетов
SELECT s.full_name AS student, d.department_name, f.faculty_name
FROM students s
JOIN departments d ON s.department_id = d.id
JOIN faculties f ON d.faculty_id = f.id;