0627-SwapSalary.sql

/* Write your T-SQL query statement below */
UPDATE salary
SET sex = (
    CASE WHEN sex = 'f'
    THEN 'm'
    ELSE 'f'
    end
)