你会如何在SQL中建立一个时间多对多的关系？

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE courses (
    id INT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE student_courses (
    student_id INT,
    course_id INT,
    start_date DATE,
    end_date DATE,
    PRIMARY KEY (student_id, course_id),
    FOREIGN KEY (student_id) REFERENCES students(id),
    FOREIGN KEY (course_id) REFERENCES courses(id)
);

SELECT c.id, c.name
FROM courses c
JOIN student_courses sc ON c.id = sc.course_id
WHERE sc.student_id = 1;

SELECT s.id, s.name
FROM students s
JOIN student_courses sc ON s.id = sc.student_id
WHERE sc.course_id = 1;