627. Swap Salary.sql

# Write your MySQL query statement below
#Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a single update query and no intermediate temp table.
UPDATE salary
    SET sex = (
        CASE WHEN sex = 'm'
            THEN 'f'
            ELSE 'm'
            END
    )