LeetCode SQL 50 Solution

[IamShiwangi]

626. Exchange Seats

[iamAntimPal]

# MYSQL Query Accepted

SELECT ( CASE
            WHEN id%2 != 0 AND id != counts THEN id+1
            WHEN id%2 != 0 AND id = counts THEN id
            ELSE id-1
        END) AS id, student
FROM seat, (select count(*) as counts from seat) 
AS seat_counts
ORDER BY id ASC

Explanation

[IamShiwangi]

Thank You I understand that Question.