the hidden column, result column id 0, would be the ts column of the outer query and inner query may not be sorted such as that diff then group by