AlgorithmJourney/LeetCode/sql/LeetCode626.sql at main · HenryJi529/AlgorithmJourney · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
select ROW_NUMBER() over (
        order by newId
    ) as "id", student
from (
        select (
                CASE
                    WHEN id % 2 = 1 then id + 1
                    WHEN id % 2 = 0 then id -1
                end
            ) newId, student
        from Seat
        order by newId
    ) t;