Leetcode Problem 626. Exchange Seats

626. Exchange Seats

Leetcode Solutions

Swapping Seats Using CASE Statement

Count the total number of seats using a subquery and alias it as counts.
Use a CASE statement to determine the new id for each student:
- If the id is odd and not the last seat, set the new id to id + 1.
- If the id is odd and the last seat, keep the id unchanged.
- If the id is even, set the new id to id - 1.
Select the new id and the student name.
Order the result by the new id in ascending order.

erDiagram
    Seat {
        int id PK
        varchar student
    }

Swapping Seats Using Bit Manipulation and COALESCE()

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...