leetcode（626） 换座位

方法一：
CASE:

# Write your MySQL query statement below
SELECT
    (
    CASE
        WHEN MOD(id,2)=1 AND CNT!=id THEN id+1
        WHEN MOD(id,2)=1 AND CNT=id THEN id
        ELSE id-1
    END
    )AS id,
    student
FROM seat,
    (SELECT COUNT(*) AS CNT
    FROM seat
    )AS S1
ORDER BY id

# Write your MySQL query statement below
SELECT
    (
    CASE
        WHEN MOD(id,2)=0 THEN id-1
        WHEN MOD(id,2)=1 AND 
            id=(SELECT COUNT(*) AS CNT
                FROM seat) THEN id
        ELSE id+1
    END
    ) AS id,
    student
FROM seat
ORDER BY id