同一用户/客户具有多个状态更改的状态开始日期和结束日期- SQL

CREATE TABLE user_status (
    user_id INT,
    status VARCHAR(50),
    start_date DATE,
    end_date DATE
);

INSERT INTO user_status (user_id, status, start_date, end_date)
VALUES (1, 'Active', '2022-01-01', '2022-02-01');

SELECT *
FROM user_status
WHERE user_id = 1
    AND start_date <= '2022-03-01'
    AND end_date >= '2022-02-01';

UPDATE user_status
SET end_date = '2022-03-01'
WHERE user_id = 1
    AND status = 'Active'
    AND end_date = '2022-02-01';