​LeetCode刷题实战626：换座位

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