Problem description A table stores status values of an object at different timestamps, with one record per timestamp. Segment rows based on changes in the status value and output the effective start timestamp and the effective end timestamp for each status segment – that is, merge consecutive records with the same status into a single time interval. Source data: Expected output (intervals where each value remains constant): Take object 1 as an example: The first three re...