Swap Salary

Easy
0/40
Average time to solve is 10m

Problem statement

Write an SQL query to swap all employee genders in the Salary table.


Table: Salary

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| id          | int      |
| name        | varchar  |
| sex         | ENUM     |
| salary      | int      |
+-------------+----------+
id is the primary key for this table.
The sex column is ENUM value of type ('m', 'f').
The table contains information about an employee.
Solution
(100% EXP penalty)
Swap Salary
Console