Exchange Seats
Seat Geek
Problem Statement
SeatGeek manages venue seating where students are seated in numerical order by their id. To mix things up, the venue wants to swap the seats of every two consecutive students.
Write an SQL query to swap the seat id for every two consecutive students. If the number of students is odd, the id of the last student is not swapped.
Rules:
- Return the result table with columns id and student.
- Results must be sorted by id in ascending order.
Tests your understanding of
Basic SQL, Conditional Logic, Math and CASE Statement
Input Tables
seat
| id(INTEGER) | student(VARCHAR) |
|---|---|
| 1 | Abbot |
| 2 | Doris |
| 3 | Emerson |
| 4 | Green |
| 5 | Jeames |
Expected Output
| id(INTEGER) | student(VARCHAR) |
|---|---|
| 1 | Doris |
| 2 | Abbot |
| 3 | Green |
| 4 | Emerson |
| 5 | Jeames |
Tags
MediumBasic SQLConditional LogicMathCASE Statement
15-20 min
68%