Swap Adjacent Relay Lanes

Problem

Table: `lane`

| Column Name | Type |
|---|---|
| lane_no | int |
| runner | varchar |

`lane_no` is the primary key. The lane numbers always start at 1 and increase without gaps.

The coach wants to swap the `runner` in each pair of adjacent lanes: lanes 1 and 2 trade places, lanes 3 and 4 trade places, and so on. If the highest lane number is odd, that last runner keeps their lane. Return the result ordered by `lane_no` ascending, with columns `lane_no` and `runner`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns lane_no, runner.

Starter code (SQL)

SELECT *
FROM lane;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium