627. Swap Salary

Solution Code

UPDATE salary
SET sex = (CASE WHEN sex = 'm' THEN 'f' 
                WHEN sex = 'f' THEN 'm' ELSE
                'a'
           END);