# Write your MySQL query statement below
update Salary
set sex =
(
case sex
when 'm' then 'f'
else 'm'
end
);
#update语句
# Write your MySQL query statement below
#对于所有座位 id 是奇数的学生,修改其 id 为 id+1,如果最后一个座位 id 也是奇数,则最后一个座位 id 不修改。对于所有座位 id 是偶数的学生,修改其 id 为 id-1。
select
(
case
when mod(id, 2) = 1 and count != id then id + 1
when mod(id, 2) = 1 and count = id then id
else id - 1
end
)as id, student
from
Seat,
(
select count(*) as count
from Seat
) as seat_count
order by id;