'Find aggregate time distinct process_name is unhealthy

I'm trying to find the aggregate time each distinct process_name is unhealthy with sql as it is the only language I know. FALSE indicates a process is unhealthy until it switches to TRUE. The real data has thousands of lines, but is always the same date. If the process ends on False, I assume it is unhealthy until the end time in query.

The desired output would be something like: ('A' '4m' |'B' 'x time')

Is this possible with SQL or do I need python/some other language?

enter image description here

sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions