为每个部门中超过50岁的女职工加薪1000元。sql语句

假设有一个包含部门名称、员工姓名、年龄、性别和薪资的员工表，表名为employee，可以使用以下SQL语句实现为每个部门中超过50岁的女职工加薪1000元：

UPDATE employee SET salary = salary + 1000 WHERE gender = '女' AND age > 50 AND department IN ( SELECT department FROM employee GROUP BY department HAVING COUNT(CASE WHEN gender = '女' AND age > 50 THEN 1 END) > 0 )