626. Exchange Seats.md

626. Exchange Seats

Question Link

Solution

# Write your MySQL query statement below
select case
when s.id%2!=0 and s.id=(select count(*) from Seat) then s.id
when s.id%2=0 then s.id-1
else
s.id+1
end as id,
student
from Seat s
order by id