Puzzle 18 Seating Chart

[maximilian22x]

AdvancedSQLPuzzles/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql

Line 828 in 66533d0

--Missing Numbers

** Also possible, but your version is better.**

WITH cte_Gaps AS
(
SELECT SeatNumber AS GapStart,
LEAD(SeatNumber,1,0) OVER (ORDER BY SeatNumber) AS GapEnd,
LEAD(SeatNumber,1,0) OVER (ORDER BY SeatNumber) - SeatNumber AS Gap
FROM #SeatingChart
)
SELECT sum((GapEnd - 1 ) - (GapStart + 1 ) + 1)
FROM cte_Gaps
WHERE Gap > 1;

GO

[smpetersgithub]

Thank you, I will check out this syntax. This puzzle was originally in Joe Celko's SQL Puzzle and Answer book, which is where I learned how to solve this puzzle.

Thank you for letting me know of all the small errors in the puzzles. Really appreciate it. Please keep them coming.

[smpetersgithub]

Closing