Соединение таблиц

Соединение трёх и более таблиц

Содержание курса

Таблицы: students (student_id PK, name), enrollments (enrollment_id PK, student_id FK, course_id FK), courses (course_id PK, title).

Какой запрос корректно возвращает имя студента и название курса, использует псевдонимы s, e, c и уточняет ими все обращения к столбцам?

SELECT name, title FROM students JOIN enrollments ON students.student_id = enrollments.student_id JOIN courses ON enrollments.course_id = courses.course_id;

SELECT s.name, c.title FROM students AS s JOIN courses AS c ON s.student_id = c.course_id JOIN enrollments AS e ON e.enrollment_id = s.student_id;

SELECT s.name, c.title FROM students AS s JOIN enrollments AS e ON s.student_id = e.student_id JOIN courses AS c ON e.enrollment_id = c.course_id;

SELECT s.name, c.title FROM students AS s JOIN enrollments AS e ON s.student_id = e.student_id JOIN courses AS c ON e.course_id = c.course_id;