ã¦ã¼ ã¶ã¼ ã®è¡åãã°ãSQL ã§åæ ex: Action A ãã Action B ã¾ã§ã®æéãç®åºããSQL SELECT "operator_name", "log_date", "operatability", "total_elapsed_time" FROM (SELECT operator_name, date(created_at) AS log_date, operatability, sum(elapsed_time) AS total_elapsed_time FROM (SELECT operator_name, created_at, lag(operatability) over(partition by operator_name, date(created_at) COALESCE(date_diff('minute', lag(created_at)
{{#tags}}- {{label}}
{{/tags}}