627-swap-salary.sql

/* 627. Swap Salary - https://leetcode.com/problems/swap-salary */

update salary
    set sex = case sex
        when 'm' then 'f'
        when 'f' then 'm'
    end