# Write your MySQL query statement below
select case
when id = (select max(id) from seat) and id%2=1 then id #last odd number is not swapped
when id%2=1 then id+1 #id % 2 = 1 is odd number. Then, add 1 to the id
else id-1 #id % 2 = 0 is even number. Then, subtract 1 from the id
end as id,
student from seat order by id
QuXiangjie
commented
4 months ago