在SQL中:如何找到两个日期值，当第一个日期值结束时，第二个日期值开始？

CREATE TABLE events (
    event_id INT PRIMARY KEY,
    start_date DATE,
    end_date DATE
);

CREATE TABLE schedules (
    schedule_id INT PRIMARY KEY,
    start_date DATE
);

SELECT 
    e.event_id,
    e.end_date AS event_end_date,
    s.start_date AS schedule_start_date
FROM 
    events e
JOIN 
    schedules s ON e.end_date < s.start_date
WHERE 
    NOT EXISTS (
        SELECT 1 
        FROM schedules s2 
        WHERE s2.start_date > e.end_date AND s2.start_date < s.start_date
    );

SELECT 
    e.event_id,
    STR_TO_DATE(e.end_date, '%Y-%m-%d') AS event_end_date,
    STR_TO_DATE(s.start_date, '%Y-%m-%d') AS schedule_start_date
FROM 
    events e
JOIN 
    schedules s ON STR_TO_DATE(e.end_date, '%Y-%m-%d') < STR_TO_DATE(s.start_date, '%Y-%m-%d')
WHERE 
    NOT EXISTS (
        SELECT 1 
        FROM schedules s2 
        WHERE STR_TO_DATE(s2.start_date, '%Y-%m-%d') > STR_TO_DATE(e.end_date, '%Y-%m-%d') AND STR_TO_DATE(s2.start_date, '%Y-%m-%d') < STR_TO_DATE(s.start_date, '%Y-%m-%d')
    );

SELECT 
    e.event_id,
    CONVERT_TZ(e.end_date, '+00:00', '+08:00') AS event_end_date,
    CONVERT_TZ(s.start_date, '+00:00', '+08:00') AS schedule_start_date
FROM 
    events e
JOIN 
    schedules s ON CONVERT_TZ(e.end_date, '+00:00', '+08:00') < CONVERT_TZ(s.start_date, '+00:00', '+08:00')
WHERE 
    NOT EXISTS (
        SELECT 1 
        FROM schedules s2 
        WHERE CONVERT_TZ(s2.start_date, '+00:00', '+08:00') > CONVERT_TZ(e.end_date, '+00:00', '+08:00') AND CONVERT_TZ(s2.start_date, '+00:00', '+08:00') < CONVERT_TZ(s.start_date, '+00:00', '+08:00')
    );