[LeetCode] 626. Exchange Seats

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH id_row AS (
    SELECT *
        , LAG(student, 1) OVER (ORDER BY id ASC) AS front_student
        , LEAD(student, 1) OVER (ORDER BY id ASC) AS back_student
    FROM Seat
)

SELECT id
     , CASE WHEN (MOD(id, 2) = 1 AND back_student IS NULL) THEN student
            WHEN MOD(id, 2) = 1 THEN back_student
            WHEN MOD(id, 2) = 0 THEN front_student
        END AS student
FROM id_row