Swap the sex value of every employee: change 'm' to 'f' and 'f' to 'm'. Use a single UPDATE statement.
sex
'm'
'f'
UPDATE
Just INSERT/UPDATE/DELETE — no trailing SELECT needed.
Sign in to see submission history
Sign in to use AI Mentor
Your query result will appear here