UPDATE employee SETgender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'ELSE genderEND