表中的每个员工每年都有一条记录。如果今年没有记录员工数据，应该通过什么查询来更改可见性

UPDATE employee_records
SET visibility = 0
WHERE year < YEAR(CURDATE());

CREATE TABLE employee_records (
    id INT PRIMARY KEY,
    employee_id INT,
    year INT,
    visibility INT DEFAULT 1
);

DELIMITER $$

CREATE TRIGGER update_visibility_on_insert
AFTER INSERT ON employee_records
FOR EACH ROW
BEGIN
    UPDATE employee_records
    SET visibility = 0
    WHERE employee_id = NEW.employee_id AND year < NEW.year;
END$$

DELIMITER ;

CREATE TABLE employee_records (
    id INT PRIMARY KEY,
    employee_id INT,
    year INT,
    data TEXT
);

CREATE VIEW current_year_records AS
SELECT *
FROM employee_records
WHERE year = YEAR(CURDATE());