Longest Run of Open Parking Bays

Problem

The table `ParkingBays` lists a parking row, one bay per row, with a `bay_no` (the position along the row) and an `is_open` flag (1 when the bay is open, 0 when it is taken). Bays are not necessarily numbered without gaps. Find the longest stretch of consecutive open bays (a run is broken whenever a bay is taken or a bay number is missing). If several stretches tie for the longest length, return each of them. For every winning stretch report `start_bay`, `end_bay`, and `run_length`, ordered by `start_bay`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns start_bay, end_bay, run_length.

Starter code (SQL)

SELECT *
FROM ParkingBays;

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