#267

Reassigning Classroom Seats

A school admin wants to preview the new seating plan: every two consecutive students swap seats. Output id and student reflecting the post-swap arrangement. If the student count is odd, the last student keeps their seat. Sort by id.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

idstudent
1Bob
2Alice
3Dave

Your query result will appear here