ELK SQL query

Hello Team,

I want to Execute SQL query on my Index data , where i have 6 records of same transaction id in Index.

In each record there is timestamp , so i need to calculate timestamp diff between 1st , 6th and 2dn ,3rd and then need calculate difference of there two difference .

The query is using Groupby By - transaction id , but i am not able to run it without non -grouped element.

Please Help !!

Hi team,

Please help!!