# Write your MySQL query statement belo
select (case
when mod(id,2) = 1 and id != (select count(*) from seat) then id+1
when mod(id,2) = 0 then id-1
when mod(id,2) = 1 and id=(select count(*) from seat) then id end
) as id,student from seat order by id# Write your MySQL query statement bel