SQL Query to Find aggregate time that each process is unhealthy

Job ID: 34149438

Budget: $10 – $30 USD

I need a SQL query 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.

See table more more information below:

https://docs.google.com/spreadsheets/d/1ACNtnc1mxWpz07kUCi5NXcTS-3j4BKGf/edit?usp=sharing&ouid=115961270400524172087&rtpof=true&sd=true
Related categories: PostgreSQL