Puzzle 19 Back to the Future

[maximilian22x]

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

Line 851 in 66533d0

*/----------------------------------------------------

Very confusing written assigment. Why 2018-01-10 2018-01-11 are in the results set? This time periode has no overlap.
overlapp.xlsx

[smpetersgithub]

The question could be reworded to something such as....

Given the following records, create a result set that merges the overlapping time frames where applicable. If a time frame does not overlap, include it in the result set as well.

[smpetersgithub]

Closing